What year did the Ingots, who left after 2007, join?
CREATE TABLE table_name_48 (year_joined VARCHAR, mascot VARCHAR, year_left VARCHAR)
SELECT COUNT(year_joined) FROM table_name_48 WHERE mascot = "ingots" AND year_left > 2007
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_48 (year_joined VARCHAR, mascot VARCHAR, year_left VARCHAR) Question: What year did the Ingots, who left after 2007, join? [/INST] SELECT COUNT(year_joined) FROM table_name_48 WHERE mascot = "ingots" AND year_left > 2007 </s>