ORDER BY Exercise Answers

Exercise #1

SELECT lastname, firstname, city
FROM customers
ORDER BY lastname;

Exercise #2

SELECT lastname, firstname, city
FROM customers
ORDER BY lastname DESC;

Exercise #3

SELECT item, price
FROM items_ordered
WHERE price > 10.00
ORDER BY price ASC;

Go Back to previous ORDER BY clause page