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
### Context: CREATE TABLE CARS_DATA (horsepower INTEGER, YEAR INTEGER) ### Question: What is the average horsepower of the cars before 1980? ### Answer: SELECT AVG(horsepower) FROM CARS_DATA WHERE YEAR < 1980