Table: all_usa_football_2
Columns: player
position
school
hometown
college

Question: Where was the hometown for the player that attended Shanley High School?
SQL: SELECT "hometown" FROM all_usa_football_2 WHERE "school" = 'Shanley High School'

Question: Which player went to the college Southern California?
SQL: SELECT "player" FROM all_usa_football_2 WHERE "college" = 'Southern California'

Question: Which college did the player attend that went to Mission Viejo High School?
SQL: SELECT "college" FROM all_usa_football_2 WHERE "school" = 'Mission Viejo High School'

Question: How many players hometown was Cincinnati, Ohio?
SQL: SELECT COUNT("player") FROM all_usa_football_2 WHERE "hometown" = 'Cincinnati, Ohio'

Question: Which player's hometown was Pewaukee, Wisconsin?
SQL: SELECT "player" FROM all_usa_football_2 WHERE "hometown" = 'Pewaukee, Wisconsin'

Question: How many players' hometown was Akron, Ohio?
SQL: SELECT COUNT("school") FROM all_usa_football_2 WHERE "hometown" = 'Akron, Ohio'