[Database] SQL Assignment 6

#1 SELECT last_name, hire_date FROM employees WHERE department_id in ( SELECT department_id FROM employees WHERE last_name = 'Zlotkey' ) AND last_name 'Zlotkey'; subquery 없이 join으로 표현하기 SELECT D.last_name, D.hire_date FROM employees E, employees D WHERE E.department_id = D.department_id AND E.last_name = 'Zlotkey' AND D.last_name 'Zlotkey' #2 SELECT employee_id, last_name FROM employees WHERE sa..

2024.04.19