Table: draft_players_3
Columns: pick
round
player
position
school

Question: What position did the person from Clemson school fill?
SQL: SELECT "position" FROM draft_players_3 WHERE "school" = 'clemson'

Question: What was Rudy Harris' pick number in round 4?
SQL: SELECT MAX("pick") FROM draft_players_3 WHERE "round" = 'round 4' AND "player" = 'rudy harris'

Question: What was the pick number for the kicker in round 8?
SQL: SELECT COUNT("pick") FROM draft_players_3 WHERE "round" = 'round 8' AND "position" = 'kicker'