SELECT avg(horsepower) FROM CARS_DATA WHERE YEAR  <  1980;
What is the average horsepower of the cars before 1980?
SELECT avg ( horsepower ) FROM CARS_DATA WHERE YEAR < 1980 ;
select avg ( horsepower ) from cars_data where year < value
What is the average horsepower of the cars before 1980 ?