[SQL Week 5 Question 500-004] Management wants to pay special attention to calls which are in progress and for which the duration is currently 20 minutes or longer (include calls of exactly 20 minutes duration). Print the ticket ID number, description, duration, priority, status, and the employee first name for all of these calls.

[SQL Week 5 Question 500-005] You suspect there has been a malware breach at the Maryland facility. Theyre not sure if its an inside job (involving one of your employees) or an outside job (involving an outside attack.) Make a listing of all high priority helpdesk tickets which have either been identified as malware, or which were taken by an employee whose location is in the Maryland facility. Print the description, duration, ticket ID number, ticket status, employee first name, employee location, and priority of ticket. Sort it alphabetically by description, then by duration (longest duration on top), then ascending by ticket ID number.

[SQL Week 5 Question 500-006] We want to see the total duration for completed helpdesk calls by employee. Only include employees who have completed helpdesk tickets; if an employee doesnt have any completed tickets, their name should not show up in this report. Generate a report for which the

First column contains the employees first and last name (dont use two columns for this put the first and last name together)

Second column contains the total duration of all completed tickets by that employee. If an employee had more than one ticket, add the durations together.

Report is sorted so the largest total duration is on the top, and then alphabetically by employee name (sort it using the First Last combination, so that Mickey Mouse would come before Nancy Mouse.)

Only include completed tickets; dont include those in progress or not yet started.

Hint: Be sure to review the Concatenation tutorial in the LEO classroom.

For example, assume your initial data was as follows.

Employee First Name	Employee Last Name	Ticket status	Ticket Duration
Mickey	Mouse	Completed	5
Mickey	Mouse	Completed	10
Donald	Duck	In Progress	15
Donald	Duck	Completed	20
Donald	Duck	Completed	25
Donald	Duck	Completed	30

Your report would contain the following information:

Employee Name	Duration of completed tickets
Donald Duck	75
Mickey Mouse	15