BUAN-SQL – Assignment 10Grouping and Filtering Grouped DataDirectionsFor each of the problems below, work out your answer in Cloud9 and then paste your USE statement and your SELECT statement into the box below the problem. Some of these problems require you to join two or more tables. Please break your SELECT statement onto a new line for each clause for readability. Do not include any SHOW or DESCRIBE statements you use to determine database, table or column names.ProblemsIn the Sales Orders database, how many orders are for only one product? (Hint: use a subquery in the FROM clause that lists the order numbers for orders having only one row and then COUNT those rows in the main query.) (1 row, final result should be 133)AnswerIn the Entertainment Agency database, show each Agent’s name, the sum of the contract price for the engagements they booked, and the agent’s total commission for agents whose total commission is more than $1000. Sort the list from highest total contracts to lowest. Make sure the total commission appears with two decimal places. (4 rows)AnswerUsing the School Scheduling Database, provide the full name of every staff member and the number of classes they have taught in order from most classes to fewest. (27 rows)Answer
Perfect Essay Writing Services 2022
Custom Academic Papers
Plagiarism Free| Quality Guaranteed| On-Time Delivery| Customized according to your instructions!
BUAN-SQL – Assignment 10 Grouping and Filtering Grouped Data Directions For each of the problems below, work out your answer in Cloud9 and then paste your USE statement and your SELECT statement into
Place Your Order Now!
All papers provided by us are written from scratch. Appropriate referencing and citation of key information are followed. Plagiarism checkers are used by the Quality assurance team and our editors just to double-check that there are no instances of plagiarism.