Friday, November 27, 2015

SQL -- Aggregate Functions (MIN)


For all of the tents that were ordered in the items_ordered table, what is the price of the lowest tent? Hint: Your query should return the price only.


SELECT MIN(price)
FROM items_ordered
WHERE item = 'Tent';


No comments:

Post a Comment