What is the average laps when the manufacturer is yamaha, and the rider is garry mccoy and the grid is smaller than 4?
CREATE TABLE table_name_71 (laps INTEGER, grid VARCHAR, manufacturer VARCHAR, rider VARCHAR)
SELECT AVG(laps) FROM table_name_71 WHERE manufacturer = "yamaha" AND rider = "garry mccoy" AND grid < 4
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_71 (laps INTEGER, grid VARCHAR, manufacturer VARCHAR, rider VARCHAR) Question: What is the average laps when the manufacturer is yamaha, and the rider is garry mccoy and the grid is smaller than 4? [/INST] SELECT AVG(laps) FROM table_name_71 WHERE manufacturer = "yamaha" AND rider = "garry mccoy" AND grid < 4 </s>