How many laps were completed by Piers Courage when BRM was the constructor and the grid is larger than 8?
CREATE TABLE table_name_25 (laps VARCHAR, grid VARCHAR, constructor VARCHAR, driver VARCHAR)
SELECT COUNT(laps) FROM table_name_25 WHERE constructor = "brm" AND driver = "piers courage" AND grid > 8
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_25 (laps VARCHAR, grid VARCHAR, constructor VARCHAR, driver VARCHAR) Question: How many laps were completed by Piers Courage when BRM was the constructor and the grid is larger than 8? [/INST] SELECT COUNT(laps) FROM table_name_25 WHERE constructor = "brm" AND driver = "piers courage" AND grid > 8 </s>