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 the box below the problem.  

Don't use plagiarized sources. Get Your Custom Essay on
Grouping and Filtering Grouped Data
Just from $13/Page
Order Essay

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.

Problems

In 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)

Answer

In 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)

Answer

Using 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)

Calculate your order
Pages (275 words)
Standard price: $0.00
Client Reviews
4.9
Sitejabber
4.6
Trustpilot
4.8
Our Guarantees
100% Confidentiality
Information about customers is confidential and never disclosed to third parties.
Original Writing
We complete all papers from scratch. You can get a plagiarism report.
Timely Delivery
No missed deadlines – 97% of assignments are completed in time.
Money Back
If you're confident that a writer didn't follow your order details, ask for a refund.

Calculate the price of your order

You will get a personal manager and a discount.
We'll send you the first draft for approval by at
Total price:
$0.00
Power up Your Academic Success with the
Team of Professionals. We’ve Got Your Back.
Power up Your Study Success with Experts We’ve Got Your Back.
error: Content is protected !!
Live Chat+1(978) 822-0999EmailWhatsApp

Order your essay today and save 20% with the discount code GOODESSAY