Question

27. Display item number, item name, and amount on hand for the items that have less than data by the on hand value. 28. Display the total on hand value for each category in the Item table. Order the results by category. 29. Display item number, item name, and amount on hand for the items that have less than 20 on hand or are storehouse 2.

Answer 1

1. Item#, Item Name,less than 20 items

Select itemNum, Description from item

where onhand <20

order by onhand

2. Total handon for each category

select category, count(*) from item

group by category

order by category

3. store house 2 or less than 20

select ItemNum, description,price from item

where handon<20 or storehouse =2