Table schema:
CREATE TABLE cars_data (horsepower INTEGER, year INTEGER)

Question: What is the average horsepower for all cars produced before 1980 ?
SQL: SELECT AVG(horsepower) FROM cars_data WHERE year < 1980