Code:
select round((pick_id-16.5)/32)+1 AS draftround, mod(pick_id-1,32)+1 as draftpick, t.in_game_id as team, player_in_game_id as playerid
FROM pick p
JOIN team t on t.team_id=p.team_id
JOIN player pl on pl.player_id=p.player_id
WHERE pick_id>0
ORDER BY pick_id
.