USE Study
GO

SELECT DNAME
FROM DEPARTMENT
WHERE DEPARTMENT.DNO = (SELECT DNO
						FROM EMPLOYEE
						WHERE EMPLOYEE.ENO = 103)

-- À§ Äõ¸®¿Í µ¿ÀÏ
SELECT DNAME
FROM DEPARTMENT
	JOIN EMPLOYEE ON EMPLOYEE.DNO = DEPARTMENT.DNO
WHERE EMPLOYEE.ENO = 103


-- ´ÜÀÏÇà ¼­ºêÄõ¸®
SELECT ENO,DNO
FROM EMPLOYEE
WHERE EMPLOYEE.DNO = (SELECT DNO FROM EMPLOYEE WHERE EMPLOYEE.ENO = 110)

-- ´ÙÁßÇà ¼­ºêÄõ¸®
SELECT ENAME, ENO,DNO, SALARY
FROM EMPLOYEE
WHERE EMPLOYEE.DNO IN (SELECT DNO FROM EMPLOYEE WHERE SALARY >= 500)

SELECT ENAME, ENO,DNO, SALARY
FROM EMPLOYEE
WHERE SALARY >= ANY (SELECT SALARY FROM EMPLOYEE WHERE DNO = 20)

SELECT ENAME, ENO,DNO, SALARY
FROM EMPLOYEE
WHERE SALARY >= ALL (SELECT SALARY FROM EMPLOYEE WHERE DNO = 10)

SELECT ENAME
FROM EMPLOYEE
WHERE EXISTS (SELECT * FROM EMPLOYEE WHERE SALARY + COMMISSION > 500)

SELECT ENO, ENAME, DNO, SALARY
FROM EMPLOYEE
WHERE DNO IN (SELECT DNO FROM EMPLOYEE WHERE ENO = 101)
	AND SALARY IN (SELECT SALARY FROM EMPLOYEE WHERE ENO = 101)


-- »óÈ£ ¿¬°ü ¼­ºêÄõ¸®: ÀϹÝÀûÀ¸·Î ¼º´ÉÀÌ ¶³¾îÁö¸ç, Á¶ÀÎÀ» ¾²´Â°Ô ÁÁÀ½
-- (¸ÞÀÎ Äõ¸®¿¡ µû¶ó ¼­ºêÄõ¸® °á°ú°¡ ´Þ¶óÁö´Â »óÈ£ ¿¬°üµÈ ¼­ºêÄõ¸®´Â ºó¹øÇÑ Á¶È¸¸¦ À¯¹ß)
SELECT ENO, ENAME, SALARY, DNO
FROM EMPLOYEE AS E
WHERE DNO IN (SELECT DNO FROM EMPLOYEE AS M WHERE E.MANAGER = M.ENO)