Table: scot_local_e07
Columns: council
2003_result
notional_control_based_on_2003_results
2007_result
details

Question: Which council has a notional control of noc and a 2007 result of no overall control (snp + ld)?
SQL: SELECT "council" FROM scot_local_e07 WHERE "notional_control_based_on_2003_results" = 'noc' AND "2007_result" = 'no overall control (snp + ld)'

Question: What's the 2007 result when the notional control is noc?
SQL: SELECT "2007_result" FROM scot_local_e07 WHERE "notional_control_based_on_2003_results" = 'noc'

Question: What's the 2003 result for the falkirk council?
SQL: SELECT "2003_result" FROM scot_local_e07 WHERE "council" = 'falkirk'

Question: What council has a 2007 result of no overall control (ind + snp)?
SQL: SELECT "council" FROM scot_local_e07 WHERE "2007_result" = 'no overall control (ind + snp)'

Question: What's the 2007 result when the notional control is noc and the 2003 result is snp?
SQL: SELECT "2007_result" FROM scot_local_e07 WHERE "notional_control_based_on_2003_results" = 'noc' AND "2003_result" = 'snp'