### Database Schema:
CREATE TABLE country (
	origin	INTEGER	NULL	PRIMARY KEY,
	country	TEXT	NULL
);

CREATE TABLE price (
	ID	INTEGER	NULL	PRIMARY KEY,
	price	REAL	NULL
);

CREATE TABLE production (
	ID	INTEGER	NULL	PRIMARY KEY,
	model_year	INTEGER	NULL	PRIMARY KEY,
	country	INTEGER	NULL,
	foreign key (ID) references data (ID),
	foreign key (country) references country (origin),
	foreign key (ID) references price (ID)
);

CREATE TABLE data (
	ID	INTEGER	NULL	PRIMARY KEY,
	mpg	REAL	NULL,
	cylinders	INTEGER	NULL,
	displacement	REAL	NULL,
	horsepower	INTEGER	NULL,
	weight	INTEGER	NULL,
	acceleration	REAL	NULL,
	model	INTEGER	NULL,
	car_name	TEXT	NULL,
	foreign key (ID) references price (ID)
);

### User's Query:
Calculate the average production rate per year from 1971 to 1980. Among them, name the cars with a weight of fewer than 1800 lbs.

### Extra Knowledge:
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