What is the average horsepower for all cars produced before 1980 ?
CREATE TABLE cars_data (horsepower INTEGER, year INTEGER)
SELECT AVG(horsepower) FROM cars_data WHERE year < 1980
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE cars_data (horsepower INTEGER, year INTEGER) Question: What is the average horsepower for all cars produced before 1980 ? [/INST] SELECT AVG(horsepower) FROM cars_data WHERE year < 1980 </s>