human
Considering the provided database schema and associated query, produce SQL code to retrieve the answer to the query. 
###Database Schema: Rank, Constituency, Winning party 2007, Swing to gain, LD's place 2007, Result
###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?
gpt
SELECT Constituency FROM table WHERE Swing to gain < 4.16 AND Winning party 2007 = snp AND LD's place 2007 = 2nd