Write a SQL statement to display the lastname, firstname and email of all owners who have an

Question:

Write a SQL statement to display the lastname, firstname and email of all owners who have an email address ending with somewhere.com. Assume that email account names can be any number of characters.

PET_OWNER (OwnerID, OwnerLastName, OwnerFirstName, OwnerPhone, OwnerEmail)

PET (PetID, PetName, PetType, PetBreed, PetDOB,?OwnerID)

image

image

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question

Database Concepts

ISBN: 978-0133544626

7th edition

Authors: David M. Kroenke, David J. Auer

Question Posted: