Question $4$

Instructions:

Enter your SQL statement in the textbox provided. Be sure to apply the rules and framework necessary that would give minimal errors if executed. It is important to provide a response as leaving

a blank question will be detrimental to the exam grade.

Background:

The database schema below is a pet appointment system for a veterinarian's office. The system is used to set up appointments for various types of pets, which may receive multiple services with

various fees.

The database schema for this system is:

PET$\_$OWNER$($OwnerID$,$ LName, FName, Phone, Email$)$

VETERINARIAN$($VetID$,$ VetLName, VetFName, OfficePhone$)$

PET$\_$TYPE$($PetTypelD$,$ PetType, Breed,$)$

PET$($PetID$,$ PetName, PetTypeID, PetDOB, PetGender, OwnerID$)$

APPOINTMENT$($PetID$,$ VetID, Date, FeeID$)$

FEE$($FeelD$,$ ServiceType, Fee$)$

Write an SQL statement that will:

List the veterinarian and total fees charged for services provided to dog pet owners that visited the office yesterday.

Edit View Insert Format Tools Table

$12$ pt $vv$ Paragraph