-- ORDER BY SELECT Sector, Symbol, Name FROM SP500 ORDER BY Sector ASC, Name ASC; -- LIMIT SELECT Name, PriceToEarnings FROM SP500 LIMIT 10 -- TOP 10 by price