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