Use the above ERD to create the sql query.

OrderDetails. Orders Customers PK OrderID. PK CustomerID PK,FK2 ProductD FK1 Customer ID UnitPrice FK2 EmployeeID Company Name ContactName Quantity Ship Name -tas--HH ContactTite Address Discount ShipCity ShipRegion Region ShipPostalCode PostalCode ShipCountry Country has FK3 ShipperID Fax OrderDate Required Date ShippedDate Products Freight PK ProductID. Employees FK1 Supplier ID PK EmployeeID CategoryID has ProductName u -has ------OH LastName EnglishNamen FirstName Quantity PerUnit Address Unit Price City UnitslnStock Shippers Province UnitsOnOrder PostalCode ReorderLevel PK ShipperlD. Phone Discontinued BirthDate Company Name has Suppliers PKS SupplierID. Name Province