Please i need with this home work , Thank you for supporting

Veterinarian Office Case Part 1 The veterinarian office created a database to keep track of owner and pet information. It also includes tracking appointments and treatments for each pet. The veterinarians need to retrieve the data for different reasons. Read the question and select the correct answer for that question. Pet Owner PET_ID int >OH OWNER_ID int PET_BREED varchar(17) OWNER_FNAME varchar(20) PET_NAME varchar(23) OWNER_LNAME varchar(30) OWNER_ID int OWNER_ST_ADDRESS varchar(50) OWNER_CITY varchar(25) OWNER_STATE char(2) OWNER_POSTAL_CODE varchar(15) OWNER_PHONE int OWNER_EMAIL varchar(30) Appointments Treatment_Appt APPOINTMENT_ID int TREATMENT_ID int PET_ID int OF APPOINTMENT_ID int APPOINTMENT_DATE date APPOINTMENT_REASON varchar(55) Treatment TREATMENT_ID int TREATMENT_PLAN varchar(55) DIAGNOSIS varchar(45)Owner OWNER_ID OWNER_FNAME |OWNER LNAME OWNER_ST_ADDRESS OWNER_CITY OWNER_STATE OWNERE_POSTAL_CODE|OWNER_PHONE OWNER_EMAIL Melissa Canton NULL NULL NV NULL NULL NULL 2 Clay Sheperd Lousetown Road VC Highlands NV 89521 3456789 chsep@gmail.com 3 Helen Harvey 345 Pine Road Reno NV 89521 3451234 hharvey@gmail.com 4 April Windon 123 Doughton Road Reno NV 89521 3454879 awindon@gmail.com 5 Emily Minden 540 Fandango Pass Road VC Highlands NV 89521 3455190 emindn@gmail.com Pet PET ID PET BREED PET NAME OWNER ID Shepherd Bailey 2 Husky Sam 2 3 Terrier Bentley 3 4 Shorthair Kiki 5 Burmese Boo 4 6 Shorthair Tigger 5 7 Parakeet Bob 5 Macaw Biranna 2Appointments APPOINTMENT ID PET ID APPOINTMENT_DATE APPOINTMENT_REASON 1 2019-10-19 No feathers 2 2019-10-11 Has temperature 3 5 2019-10-30 Weighs a lot 4 3 2019-11-05 Yearly checkup 5 5 2019-11-05 Biting people 6 1 2010-10-30 Vaccinations Treatment_Appt TREATMENT_ID APPOINTMENT_ID 2 2 3 6 6 3 4 8 5Treatment TREATMENT_ID TREATMENT_PLAN DIAGNOSIS Rest and do not run around Exhaustion 2 Put cream on feathers Feathers falling out 3 Put medicine in ears Ear mites 4 Change diet Losing weight 5 Use ointment Fur falling out 6 Get more exercise Gaining too much weight 7 Change diet and provide more exercise opportunities | Sleeps all the time 8 Take to training class Bites people 1. The veterinarians want to retrieve all the data in the Pet table. Select the correct SQL from these options. O a. SELECT * FROM Pet; O b. SELECT all FROM Pet;2. The veterinarians want to retrieve the following data from the Owner table and use aliases for all the columns retrieved. First and last name, phone number and email address. O a. SELECT OWNER_FNAME AS First Name, OWNER_LNAME AS Last Name, OWNER_PHONE AS PHONE, OWNER_EMAIL AS Email; O b. SELECT OWNER_FNAME AS "First Name', OWNER_LNAME AS ' Last Name', OWNER_PHONE AS PHONE, OWNER_EMAIL AS Email FROM Owner: 3. The veterinarians want to know how many days from today each appointment was. Use an alias for the column results. O a. SELECT CURDATE() - APPOINTMENT_DATE AS "Days since appointment" FROM Appointments; O b. SELECT TODAY_DATE - APPOINTMENT_DATE FROM Appointments; 4. The veterinarians want to know how many distinct pets are in the appointments table. Use an appropriate column name with an alias. a. SELECT PET_ID AS 'PET ID' FROM APPOINTMENTS; O b. SELECT DISTINCT PET_ID AS "PET ID' FROM APPOINTMENTS