How many cinemas have above average capacity?
SELECT count ( * )  from cinema where capacity >   ( select avg ( capacity )  from cinema ) 
above average capacity refers to capacity > AVG(capacity); number of cinemas refers to COUNT(*);