[SELECT/LEVEL4] 서울에 위치한 식당 목록 출력하기 (MySQL/Oracle)
MySQL/OracleSELECT A.REST_ID , A.REST_NAME , FOOD_TYPE , FAVORITES , ADDRESS , ROUND(AVG(REVIEW_SCORE),2) SCOREfrom REST_INFO A, REST_REVIEW Bwhere A.REST_ID = B.REST_IDAND ADDRESS LIKE '서울%'GROUP BY REST_IDORDER BY SCORE DESC,FAVORITES DESCSELECT A.REST_ID , A.REST_NAME , A.FOOD_TYPE , A.FAVORITES , A.ADDRESS , ROUND(AVG(B.REVIEW_SCORE),2) SCOREfrom RES..
2023. 4. 8.
[SELECT/LEVEL4] 오프라인/온라인 판매 데이터 통합하기 (MySQL/Oracle)
MySQLSELECT DATE_FORMAT(SALES_DATE, '%Y-%m-%d') AS SALES_DATE, PRODUCT_ID, USER_ID, SALES_AMOUNTFROM ( SELECT ONLINE_SALE_ID, USER_ID, PRODUCT_ID, SALES_AMOUNT, SALES_DATE FROM ONLINE_SALE UNION ALL SELECT OFFLINE_SALE_ID, NULL, PRODUCT_ID, SALES_AMOUNT, SALES_DATE FROM OFFLINE_SALE ) AWHERE YEAR(A.SALES_DATE) = 2022AND MONTH(A.SALES_DATE) = 3ORDER BY SALES_DATE, PRODUCT_ID, USER_..
2023. 4. 7.
[SELECT/LEVEL1] 조건에 부합하는 중고거래 댓글 조회하기 (MySQL/Oracle)
MySQLSELECT A.TITLE , A.BOARD_ID , B.REPLY_ID , B.WRITER_ID , B.CONTENTS , DATE_FORMAT(B.CREATED_DATE, '%Y-%m-%d') AS CREATED_DATEFROM USED_GOODS_BOARD A, USED_GOODS_REPLY BWHERE A.BOARD_ID = B.BOARD_IDAND DATE_FORMAT(A.CREATED_DATE, '%Y-%m') = '2022-10'ORDER BY B.CREATED_DATE ASC, A.TITLE ASC;OracleSELECT A.TITLE , A.BOARD_ID , B.REPLY_ID ..
2023. 4. 4.