Q1: The Rep table contains the Sales Representatives Q2: From the Item and Order Line table:...

Transcribed Image Text:

Q1: The Rep table contains the Sales Representatives Q2: From the Item and Order Line table: 111 11 Display the Sales Rep as "Last_Name, First_Name" in a column titled Sales Rep_Name Use the TRIM function to trim blank spaces from the Last_Name Also display the number of customers assigned to each rep as Num_Customers. Order the output by Last_Name, First_Name. Q3: From the Customer and Orders table: For Storehouse 3, display all the item Descriptions, the Sum of Num_Ordered as Total_Ordered and the Sum of On_Hand as Total_On_Hand Order the output by item Description. 1111 Q4: From the Customers and Order_Line table: Display all customers in the state of California (CA) with MORE THAN ONE order, Display their Customer_Names and the Number of Orders the customer made. Q5: From the Item and Order Line tables, 111 Display the Customer Names and the Total Sales. Order from greatest total sales to lowest total sales Calculate Total Sales as the sum of Num_Ordered * Quoted_Price Use the correct JOIN to display ALL the items by Description. Also include these columns: the average inventory price (Price in the Item table), the maximum Quoted Price and Note: The maximum and minimum will be null if no orders for that item have been placed. Q6: In the REP table, change the last name for Rep_Num 60 from Sefton to Sefton-Perez. Q7: Add Rep_num 75 to the Rep table with the following information Last Name: Doe First Name: John Street: 1717 University Drive City: Northfield State: CA Postal Code: 90098 Commission: 0 Rate: .06 Q8: Update the Customer table by assigning rep_num 75 to all customers in Northfield, CA Q9: From all the tables except the Rep table. For each order placed for num_ordered between 5 and 10 inclusive, OR that ordered on 10/13/2015, 10/14/2015, or on 10/15/2015, Display the Customer Name, Order date, item Description, and Num Ordered List the output by Order Date Q10: For the Item table, For each item that has a category of GME or PZL, and has 40 or more on hand, set the storehouse to 3 if the storehouse is not 3. Q11: From all the tables except the Rep table. List the order number and order date for each order that either was placed by a customer with Almondton in their name or contains an order line item for an item with Fire in its description List each order and order date ONLY ONCE. Q1: The Rep table contains the Sales Representatives Q2: From the Item and Order Line table: 111 11 Display the Sales Rep as "Last_Name, First_Name" in a column titled Sales Rep_Name Use the TRIM function to trim blank spaces from the Last_Name Also display the number of customers assigned to each rep as Num_Customers. Order the output by Last_Name, First_Name. Q3: From the Customer and Orders table: For Storehouse 3, display all the item Descriptions, the Sum of Num_Ordered as Total_Ordered and the Sum of On_Hand as Total_On_Hand Order the output by item Description. 1111 Q4: From the Customers and Order_Line table: Display all customers in the state of California (CA) with MORE THAN ONE order, Display their Customer_Names and the Number of Orders the customer made. Q5: From the Item and Order Line tables, 111 Display the Customer Names and the Total Sales. Order from greatest total sales to lowest total sales Calculate Total Sales as the sum of Num_Ordered * Quoted_Price Use the correct JOIN to display ALL the items by Description. Also include these columns: the average inventory price (Price in the Item table), the maximum Quoted Price and Note: The maximum and minimum will be null if no orders for that item have been placed. Q6: In the REP table, change the last name for Rep_Num 60 from Sefton to Sefton-Perez. Q7: Add Rep_num 75 to the Rep table with the following information Last Name: Doe First Name: John Street: 1717 University Drive City: Northfield State: CA Postal Code: 90098 Commission: 0 Rate: .06 Q8: Update the Customer table by assigning rep_num 75 to all customers in Northfield, CA Q9: From all the tables except the Rep table. For each order placed for num_ordered between 5 and 10 inclusive, OR that ordered on 10/13/2015, 10/14/2015, or on 10/15/2015, Display the Customer Name, Order date, item Description, and Num Ordered List the output by Order Date Q10: For the Item table, For each item that has a category of GME or PZL, and has 40 or more on hand, set the storehouse to 3 if the storehouse is not 3. Q11: From all the tables except the Rep table. List the order number and order date for each order that either was placed by a customer with Almondton in their name or contains an order line item for an item with Fire in its description List each order and order date ONLY ONCE.