DB-1.2Assignment

SELECT D.NAME AS DEPARTMENT, COUNT(P.EMAIL_ADDRESS)
FROM EMAIL.EMAILS AS E
INNER JOIN EMAIL.PERSON AS P
ON E.MESSAGE_FROM = P.EMAIL_ADDRESS
INNER JOIN EMAIL.DEPARTMENT AS D
ON P.WORKS_IN = D.ID
GROUP BY(D.NAME)