Saturday, January 2, 2016

SQL -- Aggregate Functions (Group by, MIN, MAX)


From the items_ordered table, select the item, maximum price, and minimum price for each specific item in the table. 







SELECT item, MAX(price), MIN(price)

FROM items_ordered

GROUP BY item;