Table: hoosier_ath_conf_2
Columns: school
city
team_name
county
year_joined
year_left

Question: What year did the Hornets leave the conference?
SQL: SELECT "year_left" FROM hoosier_ath_conf_2 WHERE "team_name" = 'hornets'

Question: In what city was the team that left the conference in 1949 based?
SQL: SELECT "city" FROM hoosier_ath_conf_2 WHERE "year_left" = '1949'

Question: What year did the team based in the city of Winamac join the conference?
SQL: SELECT "year_joined" FROM hoosier_ath_conf_2 WHERE "city" = 'winamac'

Question: From what county was the team that left the conference in 1993?
SQL: SELECT "county" FROM hoosier_ath_conf_2 WHERE "year_left" = '1993'

Question: From what school was the team that left the conference in 1992?
SQL: SELECT "school" FROM hoosier_ath_conf_2 WHERE "year_left" = '1992'

Question: In what year did the team from the Western school join the conference?
SQL: SELECT "year_joined" FROM hoosier_ath_conf_2 WHERE "school" = 'western'