Write an SQL statement to display all data on products having a QuantityOnHand g

Question

Write an SQL statement to display all data on products having a QuantityOnHand greater than 0.

Write an SQL statement to display the SKU, SKU_Description, and WareHouseID for products that have a QuantityOnHand greater than 0. Sort the results in descending order by WareHouseID and in ascending order by SKU.

Write an SQL statement to show a unique SKU and SKU_Description for all products having a description that includes the work ‘Climb’.


The following questions refer to the NDX table data. You can obtain a copy of the data in the Microsoft Access database DBP-e12-NDX.accdb.

1) The ChangeClose on Fridays.

2) The minimum, maximum, and average ChangeClose on Fridays.

Explanation / Answer

select * from products where QuantityOnHand > 0 select SKU,SKU_Description,WareHouseID from products where QuantityOnHand > 0 order by WareHouseID asc, SKU desc; select distinct SKU, SKU_Description from products where work='Climb'

Related Questions

Navigate

• Browse (All)
• Browse W
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.