Table: college_football_teams
Columns: school
team
city
state
conference

Question: What school has oregon as the state, and ashland as the city?
SQL: SELECT "school" FROM college_football_teams WHERE "state" = 'oregon' AND "city" = 'ashland'

Question: What conference has mayville state as the school?
SQL: SELECT "conference" FROM college_football_teams WHERE "school" = 'mayville state'

Question: What school has belleville as the city?
SQL: SELECT "school" FROM college_football_teams WHERE "city" = 'belleville'

Question: What city has trojans as the team, and taylor as the school?
SQL: SELECT "city" FROM college_football_teams WHERE "team" = 'trojans' AND "school" = 'taylor'

Question: What team has great plains as the conference, and concordia (ne) as the school?
SQL: SELECT "team" FROM college_football_teams WHERE "conference" = 'great plains' AND "school" = 'concordia (ne)'

Question: What school is in hillsboro city?
SQL: SELECT "school" FROM college_football_teams WHERE "city" = 'hillsboro'