Owners can have any number of pets. Pets can be prescribed medications by the doctors.
Write out SQL queries to answer these questions:
a) Pharmacy just called and said there was a bad batch of medicine, find the phone numbers to call for all pets prescribed that medicine.
b) Find the pets that are overdue for their annual checkup.
c) Find the owners who have had multiple pets with the same ailment.
d) What percentage of pit bulls have not had rabies vaccine shots?