Table: all_usa_football_6
Columns: player
position
school
hometown
college

Question: Which college has the player Rushel Shell?
SQL: SELECT "college" FROM all_usa_football_6 WHERE "player" = 'Rushel Shell'

Question: Which players attend Stanford college?
SQL: SELECT "player" FROM all_usa_football_6 WHERE "college" = 'Stanford'

Question: Which school is in the hometown of Aledo, Texas?
SQL: SELECT "school" FROM all_usa_football_6 WHERE "hometown" = 'Aledo, Texas'

Question: Zach Banner is a player at which school?
SQL: SELECT "school" FROM all_usa_football_6 WHERE "player" = 'Zach Banner'

Question: What position is associated with the hometown of Olney, Maryland?
SQL: SELECT COUNT("position") FROM all_usa_football_6 WHERE "hometown" = 'Olney, Maryland'

Question: Which college does the player John Theus associate with?
SQL: SELECT "college" FROM all_usa_football_6 WHERE "player" = 'John Theus'