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