The veterinarians want to a list of all the pets including the appointment id. Include all the pets even if they have not had an appointment. a. SELECT Pet.PET_ID, PET_NAME, OWNER_ID, APPOINTMENT_ID FROM Pet LEFT JOIN Appointments ON Pet.PET_ID = Appointments.PET_ID ; b. SELECT Pet.PET_ID, PET_NAME, OWNER_ID, APPOINTMENT_ID FROM Pet RIGHT JOIN Appointments ON Pet.PET_ID = Appointments.PET_ID ; c. SELECT Pet.PET_ID, PET_NAME, OWNER_ID, APPOINTMENT_ID FROM Appointments LEFT JOIN Appointments ON Appointments.PET_ID =Pet.PET_ID