This preview has intentionally blurred parts. Sign up to view the full document

View Full Document

Unformatted Document Excerpt

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; 5. Write a SQL statement to display the PetName and PetBreed of all pets sorted by PetBreed ... View Full Document

End of Preview

Sign up now to access the rest of the document