Hi I really need some help writting these SQL queries I am s

Hi I really need some help writting these SQL queries. I am stuck on 8-9 & 12-19 any help would be greatly appreciated ! thank you. im using sql plus

Solution

8.

SELECT *
FROM DOG.DOG_ID, SUM(TREATMENT.FEE * TREATMENT.DISCOUNT_RATE) as DISCOUNT
   INNER JOIN TREATMENT ON (TREATMENT.DOG_ID = DOG.DOG_ID)
GROUP BY DOG.DOG_ID

9.

CREATE VIEW VetPayments AS
SELECT VET.VET_ID, VET.FNAME, VET.LNAME, SUM(TREATMENT.FEE * (1 - TREATMENT.DISCOUNT_RATE)) as TOTAL_PAYMENT
FROM VET
   INNER JOIN TREATMENT ON (TREATMENT.VET_ID = VET.VET_ID)
GROUP BY VET.VET_ID

12.

SELECT DOG.NAME, DOG.ARRIVAL_DATE
FROM DOG
   INNER JOIN ADOPTER ON (ADOPTER.DOG_ID = DOG.DOG_ID)
GROUP BY DOG.DOG_ID

13.

SELECT DOG.NAME, DOG.ARRIVAL_DATE
FROM DOG
   LEFT JOIN ADOPTER ON (ADOPTER.DOG_ID = DOG.DOG_ID)
WHERE ADOPTER.ADOPTER_ID IS NULL
GROUP BY DOG.DOG_ID