user: Question: How many Picks have a Round larger than 8, and a College of fresno state?
Columns: ['Round', 'Pick #', 'Overall', 'Name', 'Position', 'College']
Types: ['real', 'real', 'real', 'text', 'text', 'text']
Sample row: [1.0, 9.0, 9.0, 'Rick Bryan', 'Defensive Tackle', 'Oklahoma']
SQL:

assistant: SELECT COUNT("Pick #") FROM "Table" WHERE "Round" > 8.0 AND "College" = 'fresno state';