1 write a query that will display the following: Patient name, Patient City, Patient State, Admission Date, Discharge date and duration (Number of days between admission and discharge date)

2. The Registration Management team will like to perform some analysis of the average amount of time patients stay in the hospital. The following conditions apply

If the patient has stayed in the hospital for more than 10 days, then display a duration category of >10 days

If the patient has stayed in the hospital between 3 - 9 days, then display a duration category of 3 - 9 days

If the patient has stayed in the hospital for less than 3 days, then display a duration category of < 3 days

Please extend your answer for question 1 for this question

3.The company wants to increase their profits in 2023. Given that the duration category (from question 2) is the most guaranteed way of increasing revenue and profit (The higher the stay duration, the more money they make), the company would like to know what category has the lowest number.

4.Three employees are complaining about been overworked. They believe that the workload is not shared according when it comes to distributing medication administration tasks. write a query to determine these 3 employees useing joins.

Management would like to hire 2 more drivers for their delivery process and they would like to know what cities that the drivers need to support. Their rational is to hire drivers where there the deliveries are the highest. Please write a query to show the top 2 city and state that they should consider hiring drivers