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: 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.