Table: wales_election_2011
Columns: rank
constituency
winning_party_2007
swing_to_gain
pc_s_place_2007
result

Question: What rank was caerphilly with a Swing smaller than 6.92?
SQL: SELECT COUNT("rank") FROM wales_election_2011 WHERE "swing_to_gain" < 6.92 AND "constituency" = 'caerphilly'

Question: What's the sum of swing to gain with a winning party 2007 of Conservative with a rank smaller than 5?
SQL: SELECT SUM("swing_to_gain") FROM wales_election_2011 WHERE "winning_party_2007" = 'conservative' AND "rank" < 5