CREATE TABLE table_77806 ("Rank" FLOAT, "Constituency" TEXT, "Winning party 2007" TEXT, "Swing to gain" FLOAT, "LD's place 2007" TEXT, "Result" TEXT)

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?
SELECT "Constituency" FROM table_77806 WHERE "Swing to gain" < '4.16' AND "Winning party 2007" = 'snp' AND "LD's place 2007" = '2nd'
SELECT "Constituency" FROM "table_77806" WHERE "LD's place 2007" = '2nd' AND "Swing to gain" < '4.16' AND "Winning party 2007" = 'snp'