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
average number of factories = AVG(Num_of_Factories); manufacturers that have more than 20 shops refers to num_of_shops > 20;