FINDING TIME POINTS AT WHICH PATIENT WAIT TIME IS HIGHEST OR LOWEST USING SQL

I use a data table called ‘Hospital ER’ having columns such as ‘date’, ‘patient_waittime’ to find time points at which patient wait time is highest or lowest. It is useful for HR to reallocate staff to reduce patient wait time.

SQL codes as following:

- pasted-movie.pngpasted-movie.png

-

The output with time points having highest or lowest patient wait time as follow:

-pasted-movie.png

-

pasted-movie.png

-

These findings could be used to make changes in staffing reallocation to reduce patient wait time.

-