Table Name Clinics

Answer the following questions using SQL:

What is the average turnaround time per day. (This is a difficult question because even though there is not an example record, what if a patient came in late one day around midnight and was seen the next morning)

What is the longest and the shortest timeframe a patient had to wait.

Scheduling needs a report that shows how many patients arrive each day before noon and after noon.

1 2 3 Results Messages ID First Name LastName Symptoms 1 John Doe Not feeling good 2 Mike Doe Heart Issues 3 John Doe Vomiting 4 Sarah Smith Not feeling good 5 Sam Hatley Not feeling well 6 Frank Baker Bleeding head wound 7 John Dianthea Checkin Time Seen Time 2020-08-30 14:51:23.490 2020-08-30 15:51:23.490 2020-09-01 10:51:23.490 2020-09-01 10:55:23.490 2020-09-01 12:51:23.490 2020-09-01 14:51:23.490 2020-09-01 13:51:23.490 2020-09-01 14:31:23.490 2020-09-01 15:51:23.490 2020-09-01 16:51:23.490 2020-09-01 11:51:23.490 2020-09-01 13:10:23.490 2020-09-01 09:51:23.490 2020-09-01 10:21:23.490 Severity Minor Major Medium Minor Medium Major Medium 4 5 6 7 Elliott