user: Question: What is the pick # for player David Grannis?
Columns: ['Round #', 'Pick #', 'Player', 'Position', 'Nationality', 'College/junior/club team']
Types: ['real', 'real', 'text', 'text', 'text', 'text']
Sample row: [1.0, 6.0, 'Craig Redmond', 'Defence', 'Canada', 'University of Denver ( WCHA )']
SQL:

assistant: SELECT "Pick #" FROM "Table" WHERE "Player" = 'David Grannis';