human
Considering the provided database schema and associated query, produce SQL code to retrieve the answer to the query. 
###Database Schema: Party, Constituency Seats, Regional Seats, Total Seats, Seat Change
###Question: How many regional seats were there with the SNP party and where the number of total seats was bigger than 46?
gpt
SELECT COUNT Regional Seats FROM table WHERE Party = snp AND Total Seats > 46