Table: draft_pick_player
Columns: round
pick
player
position
school_club_team

Question: Which player has a pick of 175?
SQL: SELECT "player" FROM draft_pick_player WHERE "pick" = 175

Question: Zack Jordan has the lowest pick and a round of less than 28?
SQL: SELECT MIN("pick") FROM draft_pick_player WHERE "player" = 'zack jordan' AND "round" < 28

Question: What is the sum of the pick for player roger zatkoff?
SQL: SELECT SUM("pick") FROM draft_pick_player WHERE "player" = 'roger zatkoff'