-- Database schema
| country : origin [ INTEGER ] primary_key , country [ TEXT ] | price : ID [ INTEGER ] primary_key , price [ REAL ] | data : ID [ INTEGER ] primary_key data.ID = price.ID , mpg [ REAL ] , cylinders [ INTEGER ] , displacement [ REAL ] , horsepower [ INTEGER ] , weight [ INTEGER ] , acceleration [ REAL ] , model [ INTEGER ] , car_name [ TEXT ] | production : ID [ INTEGER ] production.ID = data.ID , model_year [ INTEGER ] , country [ INTEGER ] production.country = country.origin |
-- -- Calculate the average production rate per year from 1971 to 1980. Among them, name the cars with a weight of fewer than 1800 lbs.

SELECT CAST(COUNT(T1.ID) AS REAL) / 9 FROM production AS T1 INNER JOIN data AS T2 ON T2.ID = T1.ID WHERE T1.model_year BETWEEN 1971 AND 1980 UNION ALL SELECT DISTINCT T2.car_name FROM production AS T1 INNER JOIN data AS T2 ON T2.ID = T1.ID WHERE T1.model_year BETWEEN 1971 AND 1980 AND T2.weight < 1800;