WAR (card game)

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)
from inventory;

Comments

Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

In this Discussion