What is the grid number with less than 52 laps and a Time/Retired of collision, and a Constructor of arrows - supertec?
CREATE TABLE table_name_42 (grid VARCHAR, constructor VARCHAR, laps VARCHAR, time_retired VARCHAR)
SELECT COUNT(grid) FROM table_name_42 WHERE laps < 52 AND time_retired = "collision" AND constructor = "arrows - supertec"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_42 (grid VARCHAR, constructor VARCHAR, laps VARCHAR, time_retired VARCHAR) Question: What is the grid number with less than 52 laps and a Time/Retired of collision, and a Constructor of arrows - supertec? [/INST] SELECT COUNT(grid) FROM table_name_42 WHERE laps < 52 AND time_retired = "collision" AND constructor = "arrows - supertec" </s>