Table: scot_elec_2007
Columns: rank
constituency
winning_party_2003
swing_to_gain
labour_s_place_2003
result

Question: Can you tell me the Winning party of 2003 that has the Constituency of aberdeen north?
SQL: SELECT "winning_party_2003" FROM scot_elec_2007 WHERE "constituency" = 'aberdeen north'

Question: Can you tell me the lowest Rank that has the Constituency of strathkelvin and bearsden?
SQL: SELECT MIN("rank") FROM scot_elec_2007 WHERE "constituency" = 'strathkelvin and bearsden'

Question: Can you tell me the sum of Swing to gain that has Constituency of caithness, sutherland and easter ross?
SQL: SELECT SUM("swing_to_gain") FROM scot_elec_2007 WHERE "constituency" = 'caithness, sutherland and easter ross'

Question: Can you tell me Labour's place 2003 that has the Result of con hold, and the Constituency of ayr?
SQL: SELECT "labour_s_place_2003" FROM scot_elec_2007 WHERE "result" = 'con hold' AND "constituency" = 'ayr'