IT Software Developer

① SELECT STUDENT.SNAME, ENROL.COURSE FROM ENROL INNER JOIN STUDENT ON ENROL.SNO = STUDENT.SNO; ② SELECT STUDENT.SNAME, ENROL.COURSE FROM STUDENT LEFT OUTER JOIN ENROL ON STUDENT.SNO = ENROL.SNO; ③ SELECT STUDENT.SNAME, ENROL.COURSE FROM ENROL LEFT OUTER JOIN STUDENT ON ENROL.SNO = STUDENT.SNO; ④ SELECT STUDENT.SNAME, ENROL.COURSE FROM STUDENT RIGHT OUTER JOIN ENROL ON STUDENT.SNO = ENROL.SNO; --..

CREATE TABLE ENROLL_22_61 ( Sno int(4) NOT NULL, Cno varchar(50) NOT NULL, Grade int(4) NOT NULL, PRIMARY KEY (Sno,Cno) ) ENGINE=InnoDB DEFAULT CHARSET=euckr COMMENT='2022년 61번' // INSERT INTO ENROLL_22_61 (Sno,Cno,Grade) VALUES (1001 ,'C001 ', 95), (1001 ,'M001 ', 80), (1002 ,'E001 ', 85), (1003 ,'M001 ', 90), (1004 ,'E001 ', 95), (1004 ,'M001 ', 75), (1004 ,'C001 ', 70), (1005 ,'M002 ', 80); S..

CREATE TABLE country_22_58 ( id int(4) NOT NULL, country_name varchar(50) NOT NULL, country_name_eng varchar(50) NOT NULL, ountry_code varchar(50) DEFAULT NULL, PRIMARY KEY (id) ) ENGINE=InnoDB DEFAULT CHARSET=euckr COMMENT='2022년 58번' INSERT INTO country_22_58 (id,country_name,country_name_eng,ountry_code) VALUES (1, 'Deutschland', 'Germany', 'DEU'), (2, 'Srbija', 'Serbia', 'SRB'), (3, 'Hrvatsk..

CREATE TABLE Employee_22_57 ( empno int(4) NOT NULL, ename varchar(50) NOT NULL, job varchar(50) NOT NULL, mgr varchar(50) DEFAULT NULL, deptno int(4) DEFAULT NULL, PRIMARY KEY (empno) ) ENGINE=InnoDB DEFAULT CHARSET=euckr COMMENT='2022년 57번' INSERT INTO Employee_22_57 (empno,ename,job,mgr,deptno) VALUES ('7839', 'KING', 'PRESIDENT', NULL, NULL), ('7698', 'BLAKE', 'MANAGER', '7839', 30), ('7782'..

* 위 문제는 가.나.다 를 보면 부양자(본인)과 피부양자의 이름이 같은 경우를 찾는 문제이다. -> 문제에서 설명을 거지같이 함 ㅅㅂ CREATE TABLE EMPLOYEE ( Name varchar(15) NOT NULL, Ssn char(9) NOT NULL, PRIMARY KEY (Ssn) ) ENGINE=InnoDB DEFAULT CHARSET=euckr // INSERT INTO EMPLOYEE (Ssn, Name) VALUES ('2020-001', '홍길동'), ('2019-001', '장영실'), ('2020-002', '강감찬'), ('2020-003', '류관순'), ('2019-002', '감좌진'), ('2019-003', '이몽령'), ('2019-004', '이산'), ('20..

CREATE TABLE STUDENT ( Sno int(4) NOT NULL, Sname varchar(50) NOT NULL, SYear int(4) NOT NULL, Dept varchar(50) NOT NULL, PRIMARY KEY (Sno) ) ENGINE=InnoDB DEFAULT CHARSET=euckr COMMENT='2023년 63번' // INSERT INTO STUDENT (Sno,Sname,SYear,Dept) VALUES (1, 'Tom', 2, 'Computer'), (2, 'Alice', 3, 'electronics'), (3, 'Bob', 4, 'Chemistry'), (4, 'Sam', 2, 'Computer'), (5, 'Kim', 3, 'electronics'), (6,..

CREATE TABLE Sailors ( sid int(4) NOT NULL, sname varchar(20) NOT NULL, rating int(4) DEFAULT NULL, age float DEFAULT NULL, PRIMARY KEY (sid) ) ENGINE=InnoDB DEFAULT CHARSET=euckr COMMENT='2020년 63번' INSERT INTO Sailors (sid,sname,rating,age) VALUES (22, 'Dustin', 7, 45.0), (29, 'Brutus', 1, 33.0), (31, 'Lubber', 8, 55.5), (32, 'Andy', 8, 25.5), (58, 'Rusty', 10, 35.0), (64, 'Horatio', 7, 35.0),..

DROP TABLE IF EXISTS TEST.Sailors ; DELIMITER // CREATE TABLE Sailors ( sid int(4) NOT NULL, sname varchar(20) NOT NULL, rating int(4) DEFAULT NULL, age float DEFAULT NULL, PRIMARY KEY (sid) ) ENGINE=InnoDB DEFAULT CHARSET=euckr COMMENT='2020년 63번' // INSERT INTO Sailors (sid,sname,rating,age) VALUES (22, 'Dustin', 7, 45.0), (29, 'Brutus', 1, 33.0), (31, 'Lubber', 8, 55.5), (32, 'Andy', 8, 25.5)..

DROP TABLE IF EXISTS TEST.EMP_62 ; DELIMITER // CREATE TABLE EMP_62 ( EMP varchar(50) NOT NULL, ENAME varchar(20) NOT NULL, SEX varchar(2) DEFAULT NULL, SALARY int(10) DEFAULT NULL, DEPT_NO varchar(10) DEFAULT NULL, PRIMARY KEY (EMP) ) ENGINE=InnoDB DEFAULT CHARSET=euckr COMMENT='2020년 60번' // INSERT INTO EMP_62 (EMP,ENAME,SEX,SALARY,DEPT_NO) VALUES ('2020-001', '홍길동', '남', 3000, 2), ('2019-001'..