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

how many times is the constituency edinburgh northern and leith?
SELECT COUNT("Swing to gain") FROM table_77807 WHERE "Constituency" = 'edinburgh northern and leith'
SELECT COUNT("Swing to gain") FROM "table_77807" WHERE "Constituency" = 'edinburgh northern and leith'