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