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

Share:
Home
Mobile Site | Full Site
Copyright 2017 © QuinStreet Inc. All Rights Reserved