Table: all_usa_football_10
Columns: player
position
school
hometown
college

Question: What is the hometown for tre madden?
SQL: SELECT "hometown" FROM all_usa_football_10 WHERE "player" = 'tre madden'

Question: What is the hometown for the player that is defensive back and went to alabama?
SQL: SELECT "hometown" FROM all_usa_football_10 WHERE "position" = 'defensive back' AND "college" = 'alabama'

Question: What is the college for the player that went to ridge community high school and is defensive back?
SQL: SELECT "college" FROM all_usa_football_10 WHERE "position" = 'defensive back' AND "school" = 'ridge community high school'