Who had a rank under 17 with a total of 119?
CREATE TABLE table_name_30 (athlete VARCHAR, rank VARCHAR, total VARCHAR)
SELECT athlete FROM table_name_30 WHERE rank < 17 AND total = "119"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_30 (athlete VARCHAR, rank VARCHAR, total VARCHAR) Question: Who had a rank under 17 with a total of 119? [/INST] SELECT athlete FROM table_name_30 WHERE rank < 17 AND total = "119" </s>