12 lines
421 B
MySQL
12 lines
421 B
MySQL
|
USE tutorial;
|
||
|
|
|
||
|
|
SELECT count(annualSalaryGrossEUR_Amount) FROM Employee;
|
||
|
|
SELECT sum(annualSalaryGrossEUR_Amount) FROM Employee;
|
||
|
|
SELECT avg(annualSalaryGrossEUR_Amount) FROM Employee;
|
||
|
|
|
||
|
|
SELECT Department.name, round(avg(annualSalaryGrossEUR_Amount), 2) AS salary
|
||
|
|
FROM Employee
|
||
|
|
LEFT JOIN Department ON Employee.departmentId = Department.id
|
||
|
|
GROUP BY departmentId
|
||
|
|
HAVING salary > 48000
|
||
|
|
ORDER BY salary DESC;
|