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