Create queries demonstrating INSERT, CREATE, UPDATE, SELECT, and ALTER for the following data below. DO NOT CREATE TABLES IN ORACLE. Show Queries in word. Database is Pensacola Healthcare Facility(FacilityID, SuborgID, Addr) Provider(ProviderID, FirstName, LastName, NPI, FacilityID) Patient(PatientID, FirstName, LastName, Addr) Appointment (AppointmentID, ApptTime, ProviderID, PatientID, FacilityID) 1. Write a query displaying all patients 2. Write a query showing all appointments for a patient with an ID of 2. 3. Write a query in DESC order of Addr for all facilities. 4. Write a query showing all Providers with name LIKE Smith. 5. Write a query showing appointment and patient info for the patient with ID of 5 and AppointmentID of 21. 6. Create new table called SubOrg. Insert calues for SubOrgID, OrgID, and addr. 7. make an update query to facility table where ID of facility was 3 but now is 4. 8. Write a query showing an appointment for patient with ID of 5 and providerID of 7. Ensure to include patient. FirstName patient. Lastname provider. foirstName provider. lastName, PatientID, ProviderID, appointmentID and ApptTime. Hint use Inner Join query.