Query 6 To See What Customers Are Not Keeping Up With The Times What Companies Have A Fax Number Listed Include The Co 1 (56.32 KiB) Viewed 26 times
Query 6 To see what customers are not keeping up with the times, what companies have a fax number listed? Include the contact, city, and country. */ #DELETE THIS LINE AND PASTE YOUR QUERY HERE Query 7 Generate the previous query, but limit the results to customers in Germany. */ #DELETE THIS LINE AND PASTE YOUR QUERY HERE Query 8 What are the company names, contacts, city, country, and region of Northwind's customers that live in the Americas (United States, Canada, Mexico, Argentina, Brazil, and Venezuela) but not in the cities of Campinas, Portland, or Vancouver? */ #DELETE THIS LINE AND PASTE YOUR QUERY HERE
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
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!