Table: election_results_2007
Columns: rank
constituency
winning_party_2003
swing_to_gain
snp_s_place_2003
result

Question: Which rank had the Labour party winning in 2003, a swing to gain that was larger than 2.13, a lab hold as a result, and which took place in the Linlithgow constituency?
SQL: SELECT "rank" FROM election_results_2007 WHERE "winning_party_2003" = 'labour' AND "swing_to_gain" > 2.13 AND "result" = 'lab hold' AND "constituency" = 'linlithgow'

Question: Which party won in 2003, that had a swing to gain of less than 2.92 and which resulted in a ld hold?
SQL: SELECT "winning_party_2003" FROM election_results_2007 WHERE "swing_to_gain" < 2.92 AND "result" = 'ld hold'

Question: Which constituency had the conservative party win in 2003?
SQL: SELECT "constituency" FROM election_results_2007 WHERE "winning_party_2003" = 'conservative'