user: ### NOW ANSWER:
Question: Name the total number of swing to gain with rank more than 1 and LD's place 2007 of 2nd for labour winning party of 2007
Columns: ['Rank', 'Constituency', 'Winning party 2007', 'Swing to gain', "LD's place 2007", 'Result']
Types: ['real', 'text', 'text', 'real', 'text', 'text']
Sample row: [1.0, 'Newport East', 'Labour', 2.2, '2nd', 'Labour hold']
SQL:

assistant: SELECT COUNT("Swing to gain") FROM "Table" WHERE "Rank" > 1.0 AND "LD's place 2007" = '2nd' AND "Winning party 2007" = 'labour';