fatalite

#1 SELECT LAST_NAME, HIRE_DATE FROM EMPLOYEES WHERE DEPARTMENT_ID = (SELECT DEPARTMENT_ID FROM EMPLOYEES WHERE LAST_NAME = 'Zlotkey') AND LAST_NAME 'Zlotkey'; #2 SELECT EMPLOYEE_ID, LAST_NAME FROM EMPLOYEES WHERE SALARY > (SELECT AVG(SALARY) FROM EMPLOYEES) ORDER BY SALARY; #3 SELECT EMPLOYEE_ID, LAST_NAME FROM EMPLOYEES WHERE DEPARTMENT_ID IN (SELECT DEPARTMENT_ID FROM EMPLOYEES WHERE LAST_NAME..

select * from employees; #1번 문제 select max(salary) as "Maximum", min(salary) as "Minimum", sum(salary) as "Sum", round(Avg(salary)) as "avg" from employees; #2번 문제 select JOB_ID, max(salary) as "Maximum", min(salary) as "Minimum", sum(salary) as "Sum", round(Avg(salary)) as "avg" from employees group by JOB_ID order by JOB_ID; #3번 문제 select JOB_ID, count(JOB_ID) as "count" from employees group b..