Table: conference_schools_10
Columns: school
city
mascot
county
year_joined
previous_conference
year_left
conference_joined

Question: What city joined the Independents conference after 1963?
SQL: SELECT "city" FROM conference_schools_10 WHERE "year_joined" > 1963 AND "conference_joined" = 'independents'

Question: What is the year that the Gary team with mascot of the Tornado joined?
SQL: SELECT MIN("year_joined") FROM conference_schools_10 WHERE "city" = 'gary' AND "mascot" = 'tornado'

Question: What was the previous conference for the team with the Governors as their mascot that joined the Indiana Lake Shore conference?
SQL: SELECT "previous_conference" FROM conference_schools_10 WHERE "conference_joined" = 'indiana lake shore' AND "mascot" = 'governors'

Question: What is the year that the Roughriders left the conference?
SQL: SELECT MAX("year_left") FROM conference_schools_10 WHERE "mascot" = 'roughriders'

Question: What conference did the city of Valparaiso join?
SQL: SELECT "conference_joined" FROM conference_schools_10 WHERE "city" = 'valparaiso'

Question: What is the mascot of Hammond Tech?
SQL: SELECT "mascot" FROM conference_schools_10 WHERE "city" = 'hammond' AND "school" = 'hammond tech'