What is the high lap total for a grid less than 6, and a Time/Retired of halfshaft?
CREATE TABLE table_name_68 (laps INTEGER, grid VARCHAR, time_retired VARCHAR)
SELECT MAX(laps) FROM table_name_68 WHERE grid < 6 AND time_retired = "halfshaft"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_68 (laps INTEGER, grid VARCHAR, time_retired VARCHAR) Question: What is the high lap total for a grid less than 6, and a Time/Retired of halfshaft? [/INST] SELECT MAX(laps) FROM table_name_68 WHERE grid < 6 AND time_retired = "halfshaft" </s>