Order By

orderby1.sql

SELECT *
FROM menu
ORDER BY num DESC

orderby2.sql

SELECT title, category, price
FROM menu
ORDER BY title ASC

orderby3.sql

SELECT title, category, price
FROM menu
ORDER BY category ASC,
  price DESC

1. Show the title, category and price of items in order of cheapest to most expensive
2. Show the title, category and calories of items in order of highest to lowest calorie count