Database: car_1
Question: What is the average horsepower of the cars before 1980?
SQL:
SELECT avg(horsepower) FROM CARS_DATA WHERE YEAR  <  1980;