Can you list the names of all browsers that have market shares above the average?
SELECT name FROM browser where market_share >  ( select avg ( market_share )  from browser ) 
list names where market shares above the average refers to SELECT name FROM table WHERE market_share > (SELECT AVG(market_share) FROM table);