[Database] SQL Assignment 5

#1 SELECT MAX(salary) "Maximum", MIN(salary) "Minimum", SUM(salary) "Sum", AVG(salary) "Average" FROM employees #2 SELECT job_id, MAX(salary) "Maximum", MIN(salary) "Minimum", SUM(salary) "Sum", AVG(salary) "Average" FROM employees GROUP BY job_id #3 SELECT job_id, COUNT(employee_id) FROM employees GROUP BY job_id -- COUNT(*) : 각 그룹의 투플 수를 count #4 SELECT COUNT(COUNT(MANAGER_ID)) "Number of mana..

2024.04.19