what is the average number of factories and maximum number of shops for manufacturers that opened before 1990.
CREATE TABLE manufacturer (
    num_of_shops INTEGER,
    Num_of_Factories INTEGER,
    open_year INTEGER
)
SELECT MAX(num_of_shops), AVG(Num_of_Factories) FROM manufacturer WHERE open_year < 1990
Below are sql tables schemas paired with instruction that describes a task. Using valid SQLite, write a response that appropriately completes the request for the provided tables. ### Instruction: what is the average number of factories and maximum number of shops for manufacturers that opened before 1990. ### Input: CREATE TABLE manufacturer (
    num_of_shops INTEGER,
    Num_of_Factories INTEGER,
    open_year INTEGER
) ### Response: SELECT MAX(num_of_shops), AVG(Num_of_Factories) FROM manufacturer WHERE open_year < 1990