Database: manufacturer
Question: Find the average number of factories for the manufacturers that have more than 20 shops.
SQL:
SELECT avg(Num_of_Factories) FROM manufacturer WHERE num_of_shops  >  20