Task: Text to Code
Input (English): find the average Edispl in cars_data table whose Year less than 1980
Output (English): SELECT Avg ( Edispl ) FROM cars_data WHERE Year < 1980