1. Using the table information above, write a SQL statement that will return only the following fields:

Animal name, Animal type, Animal breed, Owner name, Owner address (street, city, state, zip)

_________________________________________________________________________________________________________________________________________________

2.

Write a SQL statement that will insert the data above into the Student table with the information listed above

__________________________________________________________________________________________________________________________________________

3. Using the information above, write a SQL statement that will show only female animals that are treated by doctor number 2

_________________________________________________________________________________________________________________________________________

4. Using the information above, write a SQL statement that will count the animals that are treated by doctor number 2.

______________________________________________________________________________________________________________________________________________

5. Using the data above, write a SQL statement that will move animal Alex under the care of doctor number 2.

__________________________________________________________________________________________________________________________________________

6. Write a SQL statement that will create the table listed above.

Table: Animal AnimalID AnimalName AnimalT Piccolo Widget Gizmo Fifi Doodle AnimalBreed AnimalGenderOwner Siamese Siamese JackRussell Male Poodle Amber Doctor 2 2 14 14 Cat Cat Male Male 1 1 52 3 29 Female Female Chicken 14 Table: Owner Address OwnerName Smith Jones Apple OwnerlD 13 14 Table: Address Street 112 Main 456 Pike Ct 555 Center Lane Lakewood State CO CO AddressID Cit Denver Englewood Zi 80236 80111 80255 13