mysql 샘플 테이블 + 쿼리 연습 문제
http://java-school.net/jdbc/SQL-SELECT-Statement CREATE TABLE DEPT ( DEPTNO DECIMAL ( 2 ), DNAME VARCHAR ( 14 ), LOC VARCHAR ( 13 ), CONSTRAINT PK_DEPT PRIMARY KEY ( DEPTNO ) ); CREATE TABLE EMP ( EMPNO DECIMAL ( 4 ), ENAME VARCHAR ( 10 ), JOB VARCHAR ( 9 ), MGR DECIMAL ( 4 ), HIREDATE DATE , SAL DECIMAL ( 7 , 2 ), COMM DECIMAL ( 7 , 2 ), DEPTNO DECIMAL ( 2 ), CONSTRAINT PK_EMP PRIMARY KEY ( EMPNO ), CONSTRAINT FK_DEPTNO FOREIGN KEY ( DEPTNO ) REFERENCES DEPT ( DEPTNO ) ); CREATE TABLE SALGRADE ( GRADE TINYINT , LOSAL SMALLINT , HISAL SMALLINT ); INSE...