Table: rick_bryan_1984
Columns: round
pick
player
position
school

Question: What is the Pick # of the Player from Southern MIssissippi?
SQL: SELECT COUNT("pick") FROM rick_bryan_1984 WHERE "school" = 'southern mississippi'

Question: In what Round was Derrick Franklin picked?
SQL: SELECT "round" FROM rick_bryan_1984 WHERE "player" = 'derrick franklin'

Question: In what Round does Duke have a Pick larger than 9?
SQL: SELECT COUNT("round") FROM rick_bryan_1984 WHERE "pick" > 9 AND "school" = 'duke'

Question: In what Round was Tommy Norman picked?
SQL: SELECT MAX("round") FROM rick_bryan_1984 WHERE "player" = 'tommy norman'