Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- --1
- SELECT e2.first_name, e2.last_name FROM EMPLOYEES e1 JOIN EMPLOYEES e2 ON e1.hire_date < e2.hire_date AND e1.first_name = 'Donald';
- --2
- SELECT e1.first_name, e1.last_name, e1.hire_date, e2.first_name, e2.last_name, e2.hire_date FROM EMPLOYEES e1 JOIN EMPLOYEES e2 ON e1.manager_id = e2.employee_id AND e1.hire_date < e2.hire_date;
- --4
- SELECT MIN(e1.salary) AS "Minimum", MAX(e2.salary) AS "Maksimum", SUM(e3.salary) AS "Suma", ROUND(AVG(e4.salary),2) AS "Średnia" FROM EMPLOYEES e1 JOIN EMPLOYEES e2 ON e1.salary = e2.salary JOIN EMPLOYEES e3 ON e2.salary = e3.salary JOIN EMPLOYEES e4 ON e3.salary = e4.salary;
- --5
- SELECT COUNT(DISTINCT manager_id) AS "Ilość Menagerów" FROM EMPLOYEES;
- --6
- SELECT d.department_id, d.department_name, COUNT(e.department_id), ROUND(AVG(e.salary),2) FROM DEPARTMENTS d JOIN EMPLOYEES e ON e.department_id = d.department_id GROUP BY d.department_id, d.department_name;
- --7
- SELECT COUNT(department_id) AS "Liczba pracowników" FROM EMPLOYEES WHERE department_id = '50';
- --8
- SELECT DISTINCT department_id FROM EMPLOYEES;
- --9
- SELECT e1.department_id, ROUND(AVG(e1.salary),2) FROM EMPLOYEES e1 JOIN EMPLOYEES e2 ON e1.department_id = e2.department_id GROUP BY e1.department_id HAVING AVG(e1.salary) > 8000;
- --10
- SELECT e1.department_id, ROUND(AVG(e1.salary),2) FROM EMPLOYEES e1 JOIN EMPLOYEES e2 ON e1.department_id = e2.department_id GROUP BY e1.department_id HAVING AVG(e1.salary) = (SELECT MAX(AVG(e1.salary)) FROM EMPLOYEES e1 GROUP BY e1.department_id);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement