Which council has a notional control of noc and a 2007 result of no overall control (snp + ld)?
CREATE TABLE "councils" (
  "council" text,
  "2003_result" text,
  "notional_control_based_on_2003_results" text,
  "2007_result" text,
  "details" text
);
SELECT "council" FROM "councils" WHERE "notional_control_based_on_2003_results"='noc' AND "2007_result"='no overall control (snp + ld)';