Question: 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
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
Study Help