Table: fresno_state_bowls
Columns: bowl
score
season
opponent
stadium
location
attendance
head_coach

Question: Where was the California bowl played with 30,000 attending?
SQL: SELECT "location" FROM fresno_state_bowls WHERE "bowl" = 'california bowl' AND "attendance" = '30,000'

Question: What stadium had an opponent of Cal State Fullerton Titans?
SQL: SELECT "stadium" FROM fresno_state_bowls WHERE "opponent" = 'cal state fullerton titans'