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: how many times is the constituency edinburgh northern and leith?
gpt
SELECT COUNT Swing to gain FROM table WHERE Constituency = edinburgh northern and leith