Task: Text to Code
Input (English): What is the average horsepower for all cards produced before 1980?
Output (English): SELECT avg(horsepower) FROM CARS_DATA WHERE YEAR  <  1980