TIL 96일차 : 의사결정트리, 랜덤 포레스트, KNN, 부스팅 모델 개념

 

✏️도전한 점

---

1. 머신러닝 심화 14강~20강 학습

2. SQL 69, 70, 71, 72번까지 풀기

 

01 머신러닝 심화 학습 기록

---

 

02 SQL 코딩테스트 문제 해결 (아직)

---

69번

# SELECT DATE_FORMAT(START_DATE, '%m') AS MONTH, CAR_ID, COUNT(*) AS RECORDS
# FROM CAR_RENTAL_COMPANY_RENTAL_HISTORY
# WHERE CAR_ID IN (SELECT CAR_ID
#                  FROM CAR_RENTAL_COMPANY_RENTAL_HISTORY
#                  GROUP BY CAR_ID
#                  HAVING COUNT(DATE_FORMAT(START_DATE, '%Y-%m')) >= 5)
# GROUP BY MONTH, CAR_ID
# ORDER BY MONTH ASC, CAR_ID DESC

SELECT CAR_ID, DATE_FORMAT(START_DATE, '%Y-%m'), COUNT(*)
FROM CAR_RENTAL_COMPANY_RENTAL_HISTORY
GROUP BY 1, 2
# HAVING COUNT(DATE_FORMAT(START_DATE, '%Y-%m')) >= 5

70번

SELECT R.MEMBER_ID, COUNT(R.REVIEW_ID) AS RESULT
FROM MEMBER_PROFILE M, REST_REVIEW R
WHERE M.MEMBER_ID = R.MEMBER_ID
GROUP BY 1
ORDER BY 2 DESC

71번

SELECT SALES_DATE, PRODUCT_ID, USER_ID, SALES_AMOUNT
FROM ONLINE_SALE
WHERE DATE_FORMAT(SALES_DATE, '%m') = 3

UNION ALL

SELECT SALES_DATE, PRODUCT_ID, SALES_AMOUNT
FROM OFFLINE_SALE
WHERE DATE_FORMAT(SALES_DATE, '%m') = 3

72번

SELECT A.TITLE, A.BOARD_ID, B.REPLY_ID, B.WRITER_ID, B.CONTENTS, DATE_FORMAT(B.CREATED_DATE, '%Y-%m-%d') CREATED_DATE
FROM USED_GOODS_BOARD A, USED_GOODS_REPLY B
WHERE A.BOARD_ID = B.BOARD_ID
AND DATE_FORMAT(B.CREATED_DATE, '%Y-%m') = '2022-10'
ORDER BY B.CREATED_DATE, A.TITLE