Please assist me with writing a SQL expression to display theWarehouse and a cou

Question

Please assist me with writing a SQL expression to display theWarehouse and a count of QuantityOnHand, grouped byWarehouse. Omit all items that have a count greater than2. Name the count TotalItemsOnHand and display the results indescending order of TotalItemsOnHand. Please assist me with writing a SQL expression to display theWarehouse and a count of QuantityOnHand, grouped byWarehouse. Omit all items that have a count greater than2. Name the count TotalItemsOnHand and display the results indescending order of TotalItemsOnHand.

Explanation / Answer

Dear, SQL> SELECTWarehouse, COUNT(QuantityOnHand) AS TotalItemsOnHand
           FROMINVENTORY
           WHEREQuantityOnHand < 3
           GROUPBY Warehouse
           ORDERBY TotalItemsOnHand DESC;
I hope this will helpfulfor you................... I hope this will helpfulfor you...................

Related Questions

Navigate

• Browse (All)
• Browse P
• Subjects

---