SELECT Exercise Answers

Exercise #1

SELECT customerid, item, price
FROM items_ordered
WHERE customerid=10449;

Exercise #2

SELECT * FROM items_ordered
WHERE item = 'Tent';

Exercise #3

SELECT customerid, order_date, item
FROM items_ordered
WHERE item LIKE 's%';

Exercise #4

SELECT DISTINCT item
FROM items_ordered;

 

Go Back to previous SELECT page

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