user: ### NOW ANSWER:
Question: how many times is the constituency edinburgh northern and leith?
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, 'Argyll & Bute', 'SNP', 1.41, '2nd', 'SNP hold']
SQL:

assistant: SELECT COUNT("Swing to gain") FROM "Table" WHERE "Constituency" = 'edinburgh northern and leith';