Below is the list of tables from the database along with their columns and datatype. Need to generate an accurate SQL query for the question.
Only use the columns present in the respective table. Only use the columns which are required to generate the SQL query. Only use table joins if required and not otherwise.

### Tables ###
TABLE: CREATE TABLE table_77806 ( "Rank" real, "Constituency" text, "Winning party 2007" text, "Swing to gain" real, "LD's place 2007" text, "Result" text )

### Question ###
what is the constituency when the swing to gain is less than 4.16, the winning party 2007 is snp and ld's place 2007 is 2nd?

### Accurate SQL ###

SELECT "Constituency" FROM table_77806 WHERE "Swing to gain" < '4.16' AND "Winning party 2007" = 'snp' AND "LD's place 2007" = '2nd'