Answered step by step
Verified Expert Solution
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,
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started