Table: tuscelection_results
Columns: constituency
candidate
affiliation
votes_cast
result
loss_gain

Question: What was the loss/gain when the votes -cast was 166?
SQL: SELECT "loss_gain" FROM tuscelection_results WHERE "votes_cast" = 166

Question: Who as the candidate when the result - % was 2.9%?
SQL: SELECT "candidate" FROM tuscelection_results WHERE "result" = '2.9%'

Question: How many votes were cast when the constituency was midlothian?
SQL: SELECT "votes_cast" FROM tuscelection_results WHERE "constituency" = 'Midlothian'

Question: Who was the candidate when the result - % was 0.4%?
SQL: SELECT "candidate" FROM tuscelection_results WHERE "result" = '0.4%'

Question: What was the loss/gain when the affiliation was solidarity?
SQL: SELECT "loss_gain" FROM tuscelection_results WHERE "affiliation" = 'Solidarity'