SELECT name FROM shop WHERE number_products  >  (SELECT avg(number_products) FROM shop)
Which shops' number products is above the average? Give me the shop names.
SELECT name FROM shop WHERE number_products > ( SELECT avg ( number_products ) FROM shop )
select name from shop where number_products > ( select avg ( number_products ) from shop )
Which shops ' number products is above the average ? Give me the shop names .