Question: 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,

 We are going to create a sales report for the boss.

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

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!