Table: big_ten_football
Columns: date
time
acc_team
big_ten_team
location
television
attendance
winner
challenge_leader

Question: How many locations have #12 Michigan State as the big ten team?
SQL: SELECT COUNT("location") FROM big_ten_football WHERE "big_ten_team" = '#12 Michigan State'

Question: Who is the winner when bigten (2-1) is the challenge leader?
SQL: SELECT "winner" FROM big_ten_football WHERE "challenge_leader" = 'BigTen (2-1)'

Question: Who is the winner in the location of ljvm coliseum • winston-salem, nc?
SQL: SELECT "winner" FROM big_ten_football WHERE "location" = 'LJVM Coliseum • Winston-Salem, NC'

Question: What time was the acc team #17 wake forest?
SQL: SELECT "time" FROM big_ten_football WHERE "acc_team" = '#17 Wake Forest'

Question: Which location has a time of 9:30pm?
SQL: SELECT "location" FROM big_ten_football WHERE "time" = '9:30PM'

Question: How many dates have a big ten team of #10 purdue?
SQL: SELECT COUNT("date") FROM big_ten_football WHERE "big_ten_team" = '#10 Purdue'