CREATE TABLE manufacturer (Num_of_Factories INT, num_of_shops INT)

Find the average number of factories for the manufacturers that have more than 20 shops.
SELECT AVG(Num_of_Factories) FROM manufacturer WHERE num_of_shops > 20
SELECT AVG("Num_of_Factories") FROM "manufacturer" WHERE "num_of_shops" > 20