Question: 7 . [ SQL Week 5 Question 5 0 0 - 0 0 7 ] Do the same as Problem 6 above, except in addition

7.[SQL Week 5 Question 500-007] Do the same as Problem 6 above, except in addition to the sum of the ticket durations, also include an additional column to give us the number of completed tickets as well. Now sort your database so the largest number of completed tickets is on the top.
Here's a sample of the output for Mr. Duck and Mr. Mouse.
Employee Name Duration of completed tickets Total number of completed tickets
Donald Duck 753
Mickey Mouse 152

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!