Table: national_championships
Columns: year
host_city
host_school
champion
second_place
third_place

Question: Which years did Michigan state university come in third place?
SQL: SELECT "year" FROM national_championships WHERE "third_place" = 'Michigan State University'

Question: Who were the champions in years where michigan technological university was in third place?
SQL: SELECT "champion" FROM national_championships WHERE "third_place" = 'Michigan Technological University'

Question: What was the host city in years where the host school was école de technologie supérieure?
SQL: SELECT "host_city" FROM national_championships WHERE "host_school" = 'École de technologie supérieure'

Question: Who came in second place when the champion was south dakota school of mines & technology?
SQL: SELECT "second_place" FROM national_championships WHERE "champion" = 'South Dakota School of Mines & Technology'