Database systems Provide working SQL DML statements for the following database s

Question

Database systems

Provide working SQL DML statements for the following database schema and queries EXERCISE CUSTOMER, Type, Firstname, Lastname, Address, City) INVENTORY(ID, ItemName, Type, MadeInStore, SupplierName, DailyAverageSold, Price) ORDERS (D, customer-FI, Item-FK, Quantity, DeliveryDate) Find the best and worst selling products, ordered by the average number of units sold Best products sell more than 10 units on average, daily 1. Worst product sell 5 units or less on average, daily Show attributes: item id, item name, DailyAverageSold Find average selling number of units sold 2. products, ordered by the average Average products sell between 6 andl0 units, inclusive, per day on average Show attributes: item id, item name, DailyAverageSold

Explanation / Answer

1- select ID, ItemName, DailyAverageSold from INVENTORY where DailyAverageSold > 10 or DailyAverageSold < 5 order by DailyAverageSold

2- select ID, ItemName, DailyAverageSold from INVENTORY where DailyAverageSold >= 6 or DailyAverageSold <= 10 order by DailyAverageSold

If there is anything that you do not understand, or have any query, then please mention it in the comments section.

Related Questions

Navigate

• Browse (All)
• Browse D
• Subjects

---

---

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