This Is The Erd For The Northwind Database Products Orderdetails Orders Customers 00 1 3 Orderid 00 18 00 81 81 Supplie 1 (269.59 KiB) Viewed 88 times
This is the ERD for the Northwind database: Products OrderDetails Orders Customers 00 1 3 OrderID 00 18 00 81 81 Suppliers * SupplierID CompanyName ContactName ContactTitle Address City Region PostalCode Country Phone OrderID 7 ProductID UnitPrice Quantity Discount ProductID ProductName SupplierID CategoryID QuantityPerUnit UnitPrice UnitsInStock Units OnOrder ReorderLevel Discontinued CustomerlD Employeeld OrderDate RequiredDate ShippedDate ShipVia Freight ShipName ShipAddress ShipCity ShipRegion ShipPostalCode ShipCountry * CustomerID CompanyName ContactName ContactTitle Address City Region PostalCode Country Phone Fax Fax HomePage Employees 7 Employeeld Last Name FirstName Title TitleOfCourtesy BirthDate HireDate Address City Region PostalCode Country Home Phone Extension Photo Notes ReportsTo Shippers * ShipperID CompanyName Phone Categories 7 CategoryID CategoryName Description Picture
Query 4 In order from largest shipping fee to smallest shipping fee, what are the id, the date the order was placed, the date the order was shipped, the id of the customer who placed the order, and the shipping fee charged for all orders in the Northwind database? */ #DELETE THIS LINE AND PASTE YOUR QUERY HERE Query 5 What are the cities, companies, and contacts for Northwind's customers where the contact person works in sales, sorted by company name (go ahead and include their title in the output, just to be sure)?
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!