SELECT * FROM DEPARTMENT;
SELECT DEPTNO, DEPTNAME FROM DEPARTMENT;
SELECT TITLE FROM EMPLOYEE;
SELECT DISTINCT TITLE FROM EMPLOYEE;
SELECT * FROM EMPLOYEE WHERE DNO = 2;
SELECT * FROM EMPLOYEE WHERE DNO <> 2;
SELECT * FROM EMPLOYEE WHERE EMPNAME LIKE '이%';
SELECT FLOOR FROM DEPARTMENT WHERE DEPTNAME='영업' OR DEPTNAME='개발';
SELECT * FROM EMPLOYEE WHERE SALARY BETWEEN 3000000 AND 4500000;
SELECT * FROM EMPLOYEE WHERE SALARY >= 3000000 AND SALARY <= 4500000;
SELECT * FROM EMPLOYEE WHERE DNO IN (1, 3);
SELECT * FROM EMPLOYEE WHERE DNO NOT IN (1, 3);
SELECT EMPNAME, SALARY, SALARY * 1.1 AS NEWSALARY FROM EMPLOYEE;
SELECT * FROM EMPLOYEE WHERE MANAGER IS NULL;
SELECT * FROM EMPLOYEE WHERE MANAGER IS NOT NULL;
SELECT * FROM EMPLOYEE WHERE DNO = 2 ORDER BY SALARY;
SELECT * FROM EMPLOYEE WHERE DNO = 2 ORDER BY SALARY DESC;
SELECT * FROM EMPLOYEE WHERE DNO = 2 ORDER BY SALARY, NAME;
SELECT AVG(SALARY) AS AVGSAL, MAX(SALARY) AS MAXSAL FROM EMPLOYEE;
SELECT DNO, AVG(SALARY) AS AVGSAL, MAX(SALARY) AS MAXSAL FROM EMPLOYEE GROUP BY DNO;
SELECT DNO, AVG(SALARY) AS AVGSAL, MAX(SALARY) AS MAXSAL FROM EMPLOYEE GROUP BY DNO HAVING AVG(SALARY) >= 2500000;