Table: uk_party_leaders
Columns: leader
party
leader_s_seat
number_of_seats
leader_since

Question: Which leader has been a leader since 2007?
SQL: SELECT "leader" FROM uk_party_leaders WHERE "leader_since" = '2007'

Question: How many seats does leader Raymond McCartney have?
SQL: SELECT SUM("number_of_seats") FROM uk_party_leaders WHERE "leader" = 'raymond mccartney'

Question: Which leader of the Democratic Unionist party has more than 8 seats?
SQL: SELECT "leader" FROM uk_party_leaders WHERE "number_of_seats" > 8 AND "party" = 'democratic unionist party'