[프로그래머스 - ORACLE] 자동차 대여 기록에서 장기/단기 대여 구분하기
CREATE 문 CREATE TABLE CAR_RENTAL_COMPANY_RENTAL_HISTORY ( HISTORY_IDINTEGER, CAR_IDINTEGER, START_DATEDATE, END_DATEDATE ); INSERT INTO CAR_RENTAL_COMPANY values(1,4,to_date('2022-09-27', 'YYYY-MM-DD'),to_date('2022-11-27','YYYY-MM-DD')) INSERT INTO CAR_RENTAL_COMPANY values(2,3,to_date('2022-10-3', 'YYYY-MM-DD'),to_date('2022-11-04','YYYY-MM-DD')) INSERT INTO CAR_RENTAL_COMPANY values(3,2,to_da..
2023. 3. 20.
[프로그래머스 - ORACLE] 조건에 부합하는 중고거래 댓글 조회하기
CREATE 문 CREATE TABLE USED_GOODS_BOARD ( BOARD_IDVARCHAR2(5), WRITER_IDVARCHAR2(50), TITLEVARCHAR2(100), CONTENTSVARCHAR2(1000), PRICENUMBER, CREATED_DATEDATE, STATUSVARCHAR2(10), VIEWSNUMBER); CREATE TABLE USED_GOODS_REPLY ( REPLY_IDVARCHAR2(10) , BOARD_IDVARCHAR2(5), WRITER_IDVARCHAR2(50), CONTENTSVARCHAR2(1000), CREATED_DATEDATE); SELECT B.TITLE , B.BOARD_ID , R.REPLY_ID, R.WRITER_ID, R.CONTE..
2023. 3. 19.