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

Answer

SELECT OwnerFirstName, OwnerLastName, OwnerEmail FROM PET_OWNER JOIN PET_3 ON PET_OWNER.OwnerID = PET_3.OwnerID JOIN BREED ON PET_3.PetBreed = BREED.BreedName WHERE AverageLifeExpectancy > 15

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.