Question: Create an SQL query to solve each problem. Don't forget to include all of the following. 1. The database used USE 2. Comment with the

 Create an SQL query to solve each problem. Don't forget to

Create an SQL query to solve each problem. Don't forget to include all of the following. 1. The database used "USE" 2. Comment with the assignment name, query number, your name and date. 3. The SQL code, in a readable, programmatic format. 4. Add a brief comment for each of the main segments, what the operation will accomplish 5. The output of the messages tab, to include the full "Completion time" or "Total Execution Time" line. 6. First 5 lines of the "Results" output. Points will be deducted if missing, more than 5 , or using the TOP command. 7. Put your initials on either end of each of the four derived table names. Please create the following query: Building a CTE a. First derived table in the CTE - display CustomerID, CompanyName, Contact name and Address from the customers table. b. The second derived table in the CTE - should list CustomerID, EmployeeID, Order Date, the Required date, the ship address and Shippers ID, from the orders table. c. Third derived table in the CTE - the Employee ID, Emplquee First and last name from the Employees table. d. The fourth derived Table of the CTE - Select the ShipperiD from the Shippers table

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!