CREATE TABLE manufacturer (num_of_shops INT, Num_of_Factories INT, open_year INT)

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