CREATE TABLE furniture (furniture_id DECIMAL, name TEXT, num_of_component DECIMAL, market_rate DECIMAL)
CREATE TABLE furniture_manufacte (manufacturer_id DECIMAL, furniture_id DECIMAL, price_in_dollar DECIMAL)
CREATE TABLE manufacturer (manufacturer_id DECIMAL, open_year DECIMAL, name TEXT, num_of_factories DECIMAL, num_of_shops DECIMAL)

what is the average number of factories and maximum number of shops for manufacturers that opened before 1990.
SELECT MAX(num_of_shops), AVG(num_of_factories) FROM manufacturer WHERE open_year < 1990
SELECT MAX("num_of_shops"), AVG("num_of_factories") FROM "manufacturer" WHERE "open_year" < 1990