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. 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
Get step-by-step solutions from verified subject matter experts
