1. The veterinarians want to retrieve the owner last name, pet name, date of the appointment, treatment plan and diagnosis. Use appropriate column aliases. a. SELECT OWNER_LNAME as Owner, PET_NAME AS Pet, APPOINTMENT_DATE AS Appointment, TREATMENT_PLAN AS Plan, DIAGNOSIS FROM Owner JOIN Pet USING (OWNER_ID) JOIN APPOINTMENTS USING (PET_ID) JOIN Treatment_appt USING (APPOINTMENT_ID ) JOIN Treatment USING (TREATMENT_ID) ; b. SELECT OWNER_LNAME, PET_NAME , APPOINTMENT_DATE , TREATMENT_PLAN, DIAGNOSIS FROM Owner JOIN Pet USING (OWNER_ID) JOIN APPOINTMENTS USING (PET_ID) JOIN Treatment_appt USING APPOINTMENT_ID JOIN Treatment USING TREATMENT_ID ; c. SELECT OWNER_LNAME as Owner, PET_NAME AS Pet, APPOINTMENT_DATE AS Appointment, TREATMENT_PLAN AS Plan, DIAGNOSIS FROM Owner ,Pet ,Treatment