SQL join을 이용한 DML 연습 문제
제가 풀었던 문제와 답안입니다 참고하셔서 보시면 좋겠습니다. -- member2 create table member2( id varchar2(50) primary key, name varchar2(50) not null, gender char(1) not null, joinDate date default sysdate ); insert into member2 values('hkd','홍길동','m','2001-01-01'); insert into member2 values('lss','이순신','m','2003-02-01'); insert into member2 values('hj','황진이','f','2002-11-13'); insert into member2 values('wg','왕건','m','2..
2023. 6. 28.