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