Question

Find the average cost of treatment for each type of pet?

Answer 1

Pet ownership represents a large financial and emotional commitment. There are two main cost areas:

Pet owning initial costs: Adoption costs, training, vaccinations, etc….

Pet’s lifetime general costs: Food, toys, routine vet visits, etc….

Combining both of these costs together will give you a rough estimate of the lifetime cost of your pet.

The American Pet Products Association estimates that pet owners will spend $16.6 billion on vet care in 2017, an increase from $15.9 billion in 2016. Spending can vary widely by state, as can be seen in this map

According to Petplan, about a dozen jurisdictions including California, Hawaii and Washington, D.C., are the most expensive for vet care, averaging more than $1,400 annually.

The average cost of treatment for each type of pet:
SELECT P.PetNo, AVG(cost) AS AVERAGE_COST
FROM Treatment T, PetTreatment PT, Examination E, Pet P
WHERE P.PetNo = E.PetNo AND E.examNo = PT.examNo AND PT.treatNo = T.treatNo
GROUP BY P.PetNo;