Using the table information above, write a SQL statement that will return only t

Question

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)

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

Explanation / Answer

Answer:

select a.animalname, a.animaltype, a.animalbreed, o.ownername, ad.street,ad.city,ad.state,ad.zip from animal a , owner o, address ad where a.owner = p.ownerid and o.address=ad.addressid;

Related Questions

Navigate

• Browse (All)
• Browse U
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.