Schema: CREATE TABLE shop (name VARCHAR, number_products INTEGER)
Question: Find the names of stores whose number products is more than the average number of products.
SQL: SELECT name FROM shop WHERE number_products > (SELECT AVG(number_products) FROM shop)