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.

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.

Then, for each exercise, show the question, the query you created to get the results, and a screen capture of the results as they appear on the page of the

w3schools Web site. Your results should correspond to those of the

figures presented in this

assignment on the la

1.

Display the name, price, and category of products that cost $50 or more. Sort the resultsalphabetically by name.

2.

Display the top

five suppliers of products ordered in 1997. For each supplier, show its

name and the quantity of products.

Sort the results by quantity in descending order.

3.

Over the past year, management has noticed a lot of broken glass in the stock rooms.

Some of the products are supplied in glass jars and apparently some of the employees

arent careful enough. Write a query that displays the products packaged in

jars

.Hint

:

Look for all products with the word

jar in the Unit field.Show the product name, unit,and supplier. Sort the products alphabetically by product namest few pages.

CUSTOMERS EMPLOYEES PK CustomerID PK EmployeelD CATEGORIES LastName FirstName BirthDate Photo Notes CustomerName ContactName Address City PostalCode Country PK CategoryID CategoryName Description 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