Calculate the average production rate per year from 1971 to 1980. Among them, name the cars with a weight of fewer than 1800 lbs.
from 1971 to 1980 refers to model_year between 1971 and 1980; average production rate per year = divide(count(ID where model_year between 1971 and 1980), 9); car's name refers to car_name; a weight of fewer than 1800 lbs refers to weight < 1800
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
database name:db_id cars
country table country Cols: origin dtype integer, country dtype text, 
price table price Cols: ID dtype integer, price dtype real, 
data table data Cols: ID dtype integer, mileage per gallon dtype real, number of cylinders dtype integer, displacement dtype real, horse power dtype integer, weight dtype integer, acceleration dtype real, model dtype integer, car name dtype text, 
production table production Cols: ID dtype integer, model year dtype integer, country dtype integer, 
