Table: scot_election_2011
Columns: party
constituency_seats
regional_seats
total_seats
seat_change

Question: What is the full number of Total Seats with a constituency seat number bigger than 0 with the Liberal Democrat party, and the Regional seat number is smaller than 6?
SQL: SELECT SUM("total_seats") FROM scot_election_2011 WHERE "constituency_seats" > 0 AND "party" = 'liberal democrat' AND "regional_seats" < 6

Question: How many regional seats were there with the SNP party and where the number of total seats was bigger than 46?
SQL: SELECT COUNT("regional_seats") FROM scot_election_2011 WHERE "party" = 'snp' AND "total_seats" > 46