How long did it take for the rider of a Yamaha with a grid less than 8 and laps less than 23?
CREATE TABLE table_name_47 (time VARCHAR, laps VARCHAR, manufacturer VARCHAR, grid VARCHAR)
SELECT time FROM table_name_47 WHERE manufacturer = "yamaha" AND grid < 8 AND laps < 23
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_47 (time VARCHAR, laps VARCHAR, manufacturer VARCHAR, grid VARCHAR) Question: How long did it take for the rider of a Yamaha with a grid less than 8 and laps less than 23? [/INST] SELECT time FROM table_name_47 WHERE manufacturer = "yamaha" AND grid < 8 AND laps < 23 </s>