Number4

Download Document
Showing pages : 1 - 3 of 4
This preview has blurred sections. Sign up to view the full version! View Full Document
Assignment 4 IT 468 1. Write a SQL statement to display the PetID, PetBreed, and PetType for all pets having a four-character PetName starting with K . SELECT PET.PetID, PET.PetBreed, PET.PetType FROM PET WHERE (PET.[PetName] Like 'K___'); 2. Write a SQL statement to display the OwnerLastName, OwnerFirstName and OwnerEmail of all owners who have an email address ending with somewhere.com. Assume that email account names can be any number of characters. SELECT OwnerLastName, OwnerFirstName, OwnerEmail FROM PET_OWNER WHERE OwnerEmail LIKE '%somewhere.com'; 3. Write a SQL statement to display the OwnerLastName, OwnerFirstName and OwnerEmail of any owner who has a NULL value for OwnerPhone. SELECT OwnerLastName, OwnerFirstName, OwnerEmail FROM PET_OWNER WHERE OwnerPhone is NULL; 4. Write a SQL statement to display the PetName and PetBreed of all pets sorted by PetName. SELECT PetName, PetBreed FROM PET ORDER BY PetName;
Background image of page 1
5. Write a SQL statement to display the PetName and PetBreed of all pets sorted by PetBreed
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.