Question: Chapter 4 SQL Homework Query 3 - combination of many tables. For this query, use the Northwind Database, using SQL Server Management Studio. Create an

 Chapter 4 SQL Homework Query 3 - combination of many tables.

Chapter 4 SQL Homework Query 3 - combination of many tables. For this query, use the Northwind Database, using SQL Server Management Studio. Create an SQL statement to solve the problem. Print the query, with: 1. The database used "USE" 2. Comment with the assignment name, query number and your name 3. The SQL code 4. The output of the messages tab 5. The 4 lines of the "Results" output We are going to create a shipping report for the boss. This query will involve just a few tables. Do NOT use a CROSS JOIN Display the following: Employees table - Employee's first name, last name Territories Table - Territory description Orders table - Order date Products table - product name Region table - region description Suppliers table - Company Name (label this as Supplying Company) Customers table - Country Shippers Table - Phone Filter the output by: a. Order quantities at or greater than 70, b. territory of Boston or Cambridge, C. within the Eastern region d. unit price of 30 dollars or more e. the product name will have either "Mutton" or "Cranberry" in the name

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!