database systems

The following figure illustrates the schema of data on Blackboard (more details see homework1): Write a SQL query using the database (northwind.db) on Blackboard to get the number of category (CategoryName), the average of the unit price for each product(category) and rounded to 2 decimal places), minimum unit price for each category, maximum unit price for each category, and total units on order for categories containing greater than 10 products which means CategoryCount >10 in the query. At the end, the order need ORDER BY Categoryld Your output should look like: -- Beverages 1237.984.5263.560 -- Condiments 1223.061043.9170 -- Confections|13|25.16|9.2|81|180 -- Seafood 1220.68662.5120 The following figure illustrates the schema of data on Blackboard (more details see homework1): Write a SQL query using the database (northwind.db) on Blackboard to get the number of category (CategoryName), the average of the unit price for each product(category) and rounded to 2 decimal places), minimum unit price for each category, maximum unit price for each category, and total units on order for categories containing greater than 10 products. At the end, the order need ORDER BY Categoryld Your output should look like: - Beverages 1237.984.5263.560 -- Condiments|12|23.06|10|43.9|170 - Confections|13|25.16|9.2|81|180 -- Seafood|12|20.68|6|62.5|120