What is the year of most recent appearance of the Suncoast sound, who had more than 7 finals appearances?
CREATE TABLE table_name_95 (year_of_most_recent_appearance VARCHAR, corps_name VARCHAR, number_of_finals_appearances VARCHAR)
SELECT COUNT(year_of_most_recent_appearance) FROM table_name_95 WHERE corps_name = "suncoast sound" AND number_of_finals_appearances > 7
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_95 (year_of_most_recent_appearance VARCHAR, corps_name VARCHAR, number_of_finals_appearances VARCHAR) Question: What is the year of most recent appearance of the Suncoast sound, who had more than 7 finals appearances? [/INST] SELECT COUNT(year_of_most_recent_appearance) FROM table_name_95 WHERE corps_name = "suncoast sound" AND number_of_finals_appearances > 7 </s>