Table: p12_champs
Columns: institution
location
founded
type
enrollment
nickname
current_conference
pac_12_sports

Question: How many pac-12 sports are shown for california polytechnic state university?
SQL: SELECT COUNT("pac_12_sports") FROM p12_champs WHERE "institution" = 'California Polytechnic State University'

Question: When was the institution in boise, idaho founded?
SQL: SELECT "founded" FROM p12_champs WHERE "location" = 'Boise, Idaho'

Question: Which conference did  boise state university play at?
SQL: SELECT "current_conference" FROM p12_champs WHERE "institution" = 'Boise State University'

Question: When was the Titans founded?
SQL: SELECT MAX("founded") FROM p12_champs WHERE "nickname" = 'Titans'

Question: Which institution was founded in 1932?
SQL: SELECT "institution" FROM p12_champs WHERE "founded" = 1932

Question: Which  institution was located in bakersfield, california?
SQL: SELECT "institution" FROM p12_champs WHERE "location" = 'Bakersfield, California'