dcsimg
 

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

Home
Mobile Site | Full Site
Copyright 2018 © QuinStreet Inc. All Rights Reserved