This assignment contains ten exercises, each worth ten points, for a total of one hundred points possible. Use the Northwind database, hosted at the W3Schools Web site located at w3schools.com. For each exercise, create an SQL query that satis fi es the requirements stated in the exercise. The logical data model for the database is shown below.

Write a query that shows the number of products that belong to each category. Display the category and number of products, sorting the results by category name.

Warning!The w3schools Web site uses WebSQL (a subset of SQLite) on their site. The onlybrowsers that support WebSQL are Chrome, Safari, and Opera. Therefore, be sure to use one of those browsers. Do not use Internet Explorer or Firefox for this assignment.

query result should return like this

CUSTOMERS EMPLOYEES PK CustomerID PK EmployeelD CATEGORIES PK CategoryID Description CustomerName LastName FirstName BirthDate Photo Notes Address City PostalCode Country CategoryName PRODUCTS PK ProductlD ORDERS ORDERDETAILS PK OrderDetailID FK1 OrderID FK2 ProductID ProductName PK OrderlD FK1 CustomerID FK2 EmployeelD FK3 ShipperlD FK1 CategorylD FK2 SupplierlD Unit Price Quantity OrderDate SUPPLIERS PK SupplierlD SupplierName ContactName Address City SHIPPERS PK ShipperlD ShipperName hone