Python Programming
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
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment