[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	75	3
Mickey Mouse	15	2

[SQL Week 5 Question 500-008] You want to learn more about the average duration of all tickets taken by employees in California. Include all tickets which have been completed or are in progress by employees in California. Sort them alphabetically by priority, and then alphabetically by ticket description. Additionally, group them first by priority (highest on top), then alphabetically by description. So your final report will look something like this (your data may vary):

Priority	Description	Average duration of tickets
1-High	Malware	99
1-High	Virus	12
2-Medium	Internet	5
2-Medium	Malware	8
2-Medium	Virus	3 etc.

[SQL Week 5 Question 500-009] Your management wants to know what the different types of tickets are. Write a query that uniquely identifies ticket type based on the ticket description.