E.23 Code an SQL statement to create a view named DogBreedView that shows PetID, PetName, PetBreed, and PetDOB for dogs.
E.24 Code an SQL statement that displays the data in DogBreedView, sorted alphabetically by PetName.
E.27 Code an SQL statement to create a view named PetOwnerView that shows PetID, PetName, PetType, OwnerID, OwnerLastName, OwnerFirstName, OwnerPhone, and OwnerEmail.
E.28 Code an SQL statement that displays the data in PetOwnerView, sorted alphabetically by OwnerLastName and PetName.
E.46 Code an SQL statement to create a view named CourseEnrollmentView that shows CourseNumber, Course, CourseDate, CustomerNumber, CustomerLastName, CustomerFirstName, and Phone.
E.48 Code an SQL statement that displays the data in CourseEnrollmentView for the Beginning Oils course starting 10/15/17. Sort the data alphabetically by CustomerLastName.
E.49 Code an SQL statement to create a view named CourseFeeOwedView that shows CourseNumber, Course, CourseDate, CustomerNumber, CustomerLastName, CustomerFirstName, Phone, Fee, AmountPaid, and the calculated column (Fee – AmountPaid), renamed as AmountOwed.
E.51 Code an SQL statement that displays the data in CourseFeeOwedView, sorted alphabetically by CustomerLastName for any customer who still owes money for a course fee.
E.58 Create and run an SQL SELECT statement that answers the question: “What products were available for sale (by either catalog or Web site) in 2016 and 2017?” Sort your result by SKU.
E.59 Create and run an SQL SELECT statement that answers the question: “What products were available for sale (by either catalog or Web site) in 2015, 2016, and 2017?” Sort your result by SKU.