CREATE TABLE table_name_77 (regional_seats VARCHAR, party VARCHAR, total_seats VARCHAR)

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