What is the highest Pick, when Nationality is "France", and when Draft is less than 1979?
CREATE TABLE table_name_27 (pick INTEGER, nationality VARCHAR, draft VARCHAR)
SELECT MAX(pick) FROM table_name_27 WHERE nationality = "france" AND draft < 1979
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_27 (pick INTEGER, nationality VARCHAR, draft VARCHAR) Question: What is the highest Pick, when Nationality is "France", and when Draft is less than 1979? [/INST] SELECT MAX(pick) FROM table_name_27 WHERE nationality = "france" AND draft < 1979 </s>