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
Database Concepts
by Kroenke, David; Auer, David;
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
Update this answer!
You can help us out by revising, improving and updating this answer.
Update this answerAfter 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.
