CREATE TABLE table_name_48 (year_joined VARCHAR2, mascot VARCHAR2, year_left VARCHAR2)

What year did the Ingots, who left after 2007, join?
SELECT COUNT(year_joined) FROM table_name_48 WHERE mascot = "ingots" AND year_left > 2007
SELECT COUNT("year_joined") FROM "table_name_48" WHERE "ingots" = "mascot" AND "year_left" > 2007