Create the following queries using Data Manipulation Language (DML) - Each student must be able to explain the queries and justify the approach taken. Student 1 1. List the details of nurses allocated at orthopedic ward. 2. Identify the total number of nurses and the sum of their salaries. 3. List the details of patients whose stays at the hospital has exceeded the expected duration of stays at the ward, ordered by patient's name. Student 2 1. List the details of patients that were referred to the out-patient clinic. 2. List the number of currently available beds that are allocated in the neurology ward. 3. List the next-of-kin's details of all patients whose marital status is single, ordered by patient's name Student 3 1. List the details of patients that were allocated at the cardiology ward. 2. Identify the total number patients allocated at each ward, categorised by gender. 3. List the total number of patients who had an appointment with Dr Helen Cho. Student 4 1. List the name of each Head Nurse at each ward, ordered by ward name. 2. List the details of patients currently located in the respiratory ward. 3. List the details of patients in the dialysis ward whose stays at the hospital has not exceeded the expected duration of stays at the ward.