Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

We are going to create a sales report for the boss. This query will involve just a few tables. Do NOT use a CROSS JOIN,

image text in transcribed
We are going to create a sales report for the boss. This query will involve just a few tables. Do NOT use a CROSS JOIN, and do not use any correlated names for any table. Display in the following order: Customers table - Company name Products table - product name Orders Table - Order date Order Details Table: Unit price, Quantity, then add a field that will multiply the two together. (Label as "Total Cost" Employees table - Last and first name in one column, (label this as "Sales person") Shippers Table - Company name, (label this as "Shipping Company") Suppliers table - Company Name (label this as "Supplying Company") Filter the output by: a. The Sales Rep is Robert King c. The product names in the report are (you must look for full product names): 1. 'Cote de Blaye' 3. Thringer Rostbratwurst 4. The quantity is 20 or more 5. the Total cost over $175 Order the output by Total cost, highest price first, then by Unit price, with lowest price first

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Relational Database And Transact SQL

Authors: Lucy Scott

1st Edition

1974679985, 978-1974679980

More Books

Students also viewed these Databases questions

Question

Is it clear what happens if an employee violates the policy?

Answered: 1 week ago