Table: jets_drafts
Columns: draft
round
pick
player
nationality

Question: What is the highest Pick, when Nationality is "France", and when Draft is less than 1979?
SQL: SELECT MAX("pick") FROM jets_drafts WHERE "nationality" = 'france' AND "draft" < 1979

Question: What is the sum of Draft, when Round is greater than 9?
SQL: SELECT SUM("draft") FROM jets_drafts WHERE "round" > 9

Question: What is the highest Round, when Draft is greater than 1980, and when Player is "Shane Doan Category:Articles with hCards"?
SQL: SELECT MAX("round") FROM jets_drafts WHERE "draft" > 1980 AND "player" = 'shane doan category:articles with hcards'

Question: What is the lowest Draft, when Nationality is "Canada", when Player is "Shane Doan Category:Articles with hCards", and when Round is less than 1?
SQL: SELECT MIN("draft") FROM jets_drafts WHERE "nationality" = 'canada' AND "player" = 'shane doan category:articles with hcards' AND "round" < 1

Question: What is the lowest Draft, when Player is "Dave Christian Category:Articles with hCards"?
SQL: SELECT MIN("draft") FROM jets_drafts WHERE "player" = 'dave christian category:articles with hcards'