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 last page

4.

Northwind had record earnings in 1997. Display a list of all customers in the United

States who placed orders that year. Show the customers name, address, city, country,

and postal code.

Hint

: The

OrderDate

should start with

1997

and the

Country

is

USA

.

5.

Display all the orders placed in February of 1997, showing the order number, the

customers name, and the name of the employee who created the order.

Hint

: Use the

BETWEEN

keyword to select data within a range. In SQLite, dates are delimited with single

quotes and have the format

YYYY-MM-DD

.

6.

The executives at Northwind want to know the

fi

ve 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.

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