Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Write an SQL statement to display the OwnerLastName, OwnerFirstName, PetName, PetType, PetBreed, and AverageLifeExpectancy for pets with a known PetBreed. Use PET_3. The PET_OWNER, PET_3,
Write an SQL statement to display the OwnerLastName, OwnerFirstName, PetName, PetType, PetBreed, and AverageLifeExpectancy for pets with a known PetBreed. Use PET_3. The PET_OWNER, PET_3, and BREED tables are below.
OwnerID | OwnerLastName | OwnerFirstName | OwnerPhone | OwnerEmail |
---|---|---|---|---|
1 | Downs | Marsha | 555-537-8765 | Marsha.Downs@somewhere.com |
2 | James | Richard | 555-537-7654 | Richard.James@somewhere.com |
3 | Frier | Liz | 555-537-6543 | Liz.Frier@somewhere.com |
4 | Trent | Miles | Miles.Trent@different.com |
PetID | PetName | PetType | PetBreed | PetDOB | PetWeight | OwnerID |
---|---|---|---|---|---|---|
1 | King | Dog | Std. Poodle | 2009-02-27 00:00:00 | 25.5 | 1 |
2 | Teddy | Cat | Cashmere | 2010-02-01 00:00:00 | 10.5 | 2 |
3 | Fido | Dog | Std. Poodle | 2008-07-17 00:00:00 | 28.5 | 1 |
4 | AJ | Dog | Collie Mix | 2009-05-05 00:00:00 | 20.0 | 3 |
5 | Cedro | Cat | Unknown | 2007-06-06 00:00:00 | 9.5 | 2 |
6 | Wooley | Cat | Unknown | 9.5 | 2 | |
7 | Buster | Dog | Border Collie | 2006-12-11 00:00:00 | 25.0 | 4 |
BreedName | MinWeight | MaxWeight | AverageLifeExpectancy |
---|---|---|---|
Border Collie | 15.0 | 22.5 | 20 |
Cashmere | 10.0 | 15.0 | 12 |
Collie Mix | 17.5 | 25.0 | 18 |
Std. Poodle | 22.5 | 30.0 | 18 |
Unknown |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started