An airline tracks ticket sales in a tickets table. Managemen…
An airline tracks ticket sales in a tickets table. Management wants to see the highest-priced tickets first. Which query should they write? SELECT * FROM tickets ORDER BY price ASC SELECT * FROM tickets ORDER BY price DESC SELECT * FROM tickets GROUP BY price SELECT * FROM tickets WHERE price DESC Answer: SELECT * FROM tickets ORDER BY price DESC Explanation: DESC sorts from largest to smallest, so the most expensive tickets appear first. ASC would do the opposite. GROUP BY and WHERE are not used for sorting.