What is the average horsepower of the cars 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 of the cars before 1980? [/INST] SELECT AVG(horsepower) FROM CARS_DATA WHERE YEAR < 1980 </s>