$2.$ Using the following tables: PET$\_$OWNER$($OwnerID$,$ Name, Phone, Email, Street,City,State,Zip$),$ PET$($PetID$,$ Name, Type, Breed, DOB, OwnerID$)$

Write SQL statements to do the following:

$($a$)$ Write CREATE TABLE statements to create the tables shown above. $($Be sure to first check to see if the table already exists and drop the old one if necessary.$)$

$($b$)$ Write SQL statements to add at least $3$ rows to the PET$\_$OWNER table. $($c$)$ Write SQL statements to add at least $5$ rows to the PET table.

$($d$)$ Write a SQL statement to display all of the columns and all of the rows of PET.

$($e$)$ Write a SQL statement to display the Name, Breed and Type of all pets on file.

$($f$)$ Write a SQL statement to display the Name, Breed and Type for all pets that are of the Type "Dog" and the Breed "Poodle".

$($g$)$ Write a SQL statement to display the Name, Breed, and Type for all pets that are not of Type Cat, Dog, or Fish.

$($h$)$ Write a SQL statement to display all owners in the $10012$ zipcode.

$($i$)$ Write a SQL statement to display the pet$$s Name, Breed, and the owner$$s name.

$($j$)$ Write a SQL statement to count the number of pets on file.

$($k$)$ Write a SQL statement to count the number of pets in the $10003$ zipcode.

$($l$)$ Write a SQL statement to display the name and phone number of all cat owners