What is the name and location of the 2 cinemas with above average capacity?
SELECT name, location from cinema where capacity >   ( select avg ( capacity )  from cinema ) 
name and location refers to selecting name, location columns; 2 cinemas with above average capacity implies filtering cinemas where capacity is greater than the average capacity of all cinemas;