Advertisement
Guest User

Untitled

a guest
Mar 29th, 2015
305
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 1.48 KB | None | 0 0
  1. --1
  2. 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';
  3. --2
  4. 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;
  5. --4
  6. 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;
  7. --5
  8. SELECT COUNT(DISTINCT manager_id) AS "Ilość Menagerów" FROM EMPLOYEES;
  9. --6
  10. 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;
  11. --7
  12. SELECT COUNT(department_id) AS "Liczba pracowników" FROM EMPLOYEES WHERE department_id = '50';
  13. --8
  14. SELECT DISTINCT department_id FROM EMPLOYEES;
  15. --9
  16. 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;
  17. --10
  18. 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