25-25b

25.
SELECT d.deptname, SUM(e.salary) AS suma_zarobkow_w_dziale, (SELECT AVG(salary) FROM employee) AS ogolna_srednia_zarobkow
FROM department d
JOIN employee e
ON e.workdept = d.deptno
GROUP BY d.deptname
HAVING SUM(e.salary) > (SELECT AVG(salary) FROM employee);

25a.
SELECT d.deptname, SUM(CAST(e.salary AS INT)) AS suma_zarobkow_w_dziale, (SELECT AVG(CAST(salary AS INT)) FROM employee) AS ogolna_srednia_zarobkow
FROM department d
JOIN employee e
ON e.workdept = d.deptno
GROUP BY d.deptname
HAVING SUM(e.salary) > (SELECT AVG(salary) FROM employee);

25b.
SELECT CAST(d.deptname AS VARCHAR(3)), SUM(CAST(e.salary AS INT)) AS suma_zarobkow_w_dziale, (SELECT AVG(CAST(salary AS INT)) FROM employee) AS ogolna_srednia_zarobkow
FROM department d
JOIN employee e
ON e.workdept = d.deptno
GROUP BY d.deptname
HAVING SUM(e.salary) > (SELECT AVG(salary) FROM employee);