Table: draft_pick_players
Columns: round
pick
player
nationality
school

Question: Which pick was from Lamar High School?
SQL: SELECT "pick" FROM draft_pick_players WHERE "school" = 'lamar high school'

Question: Which nationality does Florida Tech have?
SQL: SELECT "nationality" FROM draft_pick_players WHERE "school" = 'florida tech'

Question: Which nationality's pick was 415?
SQL: SELECT "nationality" FROM draft_pick_players WHERE "pick" = '415'

Question: Which school's nationality was United States when its pick was 595?
SQL: SELECT "school" FROM draft_pick_players WHERE "nationality" = 'united states' AND "pick" = '595'

Question: Which school's round was 24?
SQL: SELECT "school" FROM draft_pick_players WHERE "round" = '24'