CREATE TABLE table_57332 ("Council" CLOB, "2003 result" CLOB, "Notional control  ( based on 2003 results ) " CLOB, "2007 result" CLOB, "Details" CLOB)

What's the 2007 result when the notional control is noc and the 2003 result is snp?
SELECT "2007 result" FROM table_57332 WHERE "Notional control (based on 2003 results)" = 'noc' AND "2003 result" = 'snp'
SELECT "2007 result" FROM "table_57332" WHERE "2003 result" = 'snp' AND "Notional control (based on 2003 results)" = 'noc'