data aggregation example - muhamed-hassan/messaging-poc GitHub Wiki

Example taken from Lesson 5

---

Get report about:

• Count of employees grouped by department
• Salaries summation of employees grouped by department

SELECT `department`.`dname` AS 'Department name', COUNT(`ssn`) AS 'Employees count', SUM(`salary`) AS 'Summation of employees salaries'
FROM `employee`
  INNER JOIN `department` ON `employee`.`dno` = `department`.`dnumber`
WHERE `employee`.`super_ssn` IS NOT NULL
GROUP BY `department`.`dname`;

---