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  <  1980;
[{'avg(horsepower)': 111.13291139240506}]