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