[프로그래머스 - ORACLE] 오프라인/온라인 판매 데이터 통합하기
CREATE 문 CREATE TABLE ONLINE_SALE ( ONLINE_SALE_IDNUMBERNOT NULL, USER_IDNUMBERNOT NULL, PRODUCT_IDNUMBERNOT NULL, SALES_AMOUNTNUMBERNOT NULL, SALES_DATEDATENOT NULL ); CREATE TABLE OFFLINE_SALE ( OFFLINE_SALE_IDNUMBERNOT NULL, PRODUCT_IDNUMBERNOT NULL, SALES_AMOUNTNUMBERNOT NULL, SALES_DATEDATENOT NULL ); 내 풀이 SELECT SALES_DATE , PRODUCT_ID, USER_ID, SALES_AMOUNT FROM( SELECT TO_CHAR(SALES_DATE..
2023. 3. 20.
