Database: car_1
Question: What is the average horsepower for all cars produced before 1980 ?
SQL:
select avg(horsepower) from cars_data where year  <  1980;