Database Concepts

Published by Pearson
ISBN 10: 0133544621
ISBN 13: 978-0-13354-462-6

Chapter 3 - Structured Query Language - Figure 3-20 - Pet_3 Data - Page 215: 3.41

Answer

SELECT OwnerFirstName, OwnerLastName, PetName, PetType, PET_3.PetBreed, AverageLifeExpectancy FROM PET_OWNER JOIN PET_3 ON PET_OWNER.OwnerID = PET_3.OwnerID JOIN BREED ON PET_3.PetBreed = BREED.BreedName WHERE PET_3.PetBreed != 'Unknown'

Work Step by Step

N/A
Update this answer!

You can help us out by revising, improving and updating this answer.

Update this answer

After you claim an answer you’ll have 24 hours to send in a draft. An editor will review the submission and either publish your submission or provide feedback.

GradeSaver will pay $15 for your literature essays
GradeSaver will pay $25 for your college application essays
GradeSaver will pay $50 for your graduate school essays – Law, Business, or Medical
GradeSaver will pay $10 for your Community Note contributions
GradeSaver will pay $500 for your Textbook Answer contributions