Table schema:
CREATE TABLE CARS_DATA (horsepower INTEGER, YEAR INTEGER)

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