My table consists of the following columns
inv_id, item_id, item_size, color, price and qoh(quantity on hand)
the table name is inventory
I have a query which is giving me a problem.
The query is as follows:
For each size in the INVENTORY TABLE, display the size and the average price of all items of that size.
Any ideas how to do this...
I tried the following but did not work...
select item_size, avg(price)