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