Name the highest Long that has an Avg/G smaller than 8.4, and an GP-GS of 4–0?
CREATE TABLE table_name_88 (long INTEGER, avg_g VARCHAR, gp_gs VARCHAR)
SELECT MAX(long) FROM table_name_88 WHERE avg_g < 8.4 AND gp_gs = "4–0"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_88 (long INTEGER, avg_g VARCHAR, gp_gs VARCHAR) Question: Name the highest Long that has an Avg/G smaller than 8.4, and an GP-GS of 4–0? [/INST] SELECT MAX(long) FROM table_name_88 WHERE avg_g < 8.4 AND gp_gs = "4–0" </s>