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 satisfies the requirements stated in the exercise. The logical data model for the database is shown below.

Warning! The w3schools Web site uses WebSQL (a subset of SQLite) on their site. The only browsers 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- The executives at Northwind want to know the five most expensive products and who supplies them. Display each products name, price, and the supplier. Sort the results by price from high to low.

Hint: Only include products that customers have ordered. and dont forget only 5 products

the query result should look 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