Question

Consider the Inventory table given below:
ITEM
Bread
Biscuit
Cup Noodles
Chips
Quantity
15
20
NULL
25
Select avg(Quantity) from Inventory:
What is the output of the above query?​

Answer 1

Answer:

In an inventory management system implemented at a trading corporation, there are several tables designed to hold all the information. Amongst these, the following two tables hold information on which items are supplied by which suppliers, and which warehouse keeps which items along with the stock-level of these items.

Supply = (supplierid, itemcode)

Inventory = (itemcode, warehouse, stocklevel)

For a specific information required by the management, following SQL query has been written

Explanation:

it can help you

make me brilliant