Data Analyst KIM

WITH tab AS ( SELECT car.daily_fee , car.car_type , his.history_id , DATEDIFF(END_DATE, START_DATE) + 1 AS period , CASE WHEN DATEDIFF(END_DATE, START_DATE) + 1 >= 90 THEN '90일 이상' WHEN DATEDIFF(END_DATE, START_DATE) + 1 >= 30 THEN '30일 이상' WHEN DATEDIFF(END_DATE, START_DATE) + 1 >= 7 THEN '7일 이상' ELSE 'NONE' END AS duration_type FROM CAR_RENTAL_COMPANY_RENTAL_HISTORY AS his INNER JOIN CAR_RENTA..

SELECT DATE_FORMAT(SALES_DATE,"%Y-%m-%d") SALES_DATE , PRODUCT_ID , USER_ID , SALES_AMOUNT FROM ONLINE_SALE WHERE SALES_DATE >= '2022-03-01' and SALES_DATE = '2022-03-01' and SALES_DATE < '2022-04-01' ORDER BY SALES_DATE , PRODUCT_ID , USER_ID

SELECT MEMBER_NAME , REVIEW_TEXT , DATE_FORMAT(r.REVIEW_DATE,'%Y-%m-%d') AS REVIEW_DATE FROM MEMBER_PROFILE m INNER JOIN REST_REVIEW r ON m.MEMBER_ID=r.MEMBER_ID WHERE m.MEMBER_ID = (SELECT MEMBER_ID FROM REST_REVIEW GROUP BY MEMBER_ID ORDER BY COUNT(MEMBER_ID) DESC LIMIT 1) ORDER BY REVIEW_DATE,REVIEW_TEXT

SELECT MONTH(START_DATE) AS MONTH , CAR_ID , COUNT(*) AS RECORDS FROM CAR_RENTAL_COMPANY_RENTAL_HISTORY WHERE DATE_FORMAT(START_DATE,'%Y-%m') BETWEEN '2022-08' AND '2022-10' AND CAR_ID IN (SELECT CAR_ID FROM CAR_RENTAL_COMPANY_RENTAL_HISTORY WHERE DATE_FORMAT(START_DATE,'%Y-%m') BETWEEN '2022-08' AND '2022-10' GROUP BY CAR_ID HAVING COUNT(CAR_ID) >= 5) GROUP BY MONTH(START_DATE), CAR_ID HAVING R..

SELECT a.AUTHOR_ID , a.AUTHOR_NAME , b.CATEGORY , SUM((SALES * PRICE)) AS TOTAL_SALES FROM BOOK b INNER JOIN AUTHOR a ON b.AUTHOR_ID = a.AUTHOR_ID INNER JOIN BOOK_SALES bs ON b.BOOK_ID = bs.BOOK_ID WHERE bs.SALES_DATE LIKE '2022-01%' GROUP BY b.CATEGORY, b.AUTHOR_ID ORDER BY AUTHOR_ID, CATEGORY DESC

SELECT CONCAT('/home/grep/src/',f.BOARD_ID,'/',f.FILE_ID,f.FILE_NAME,f.FILE_EXT) AS FILE_PATH FROM USED_GOODS_BOARD b INNER JOIN USED_GOODS_FILE f ON b.BOARD_ID = f.BOARD_ID WHERE b.views = (SELECT MAX(views) FROM USED_GOODS_BOARD) ORDER BY FILE_ID DESC