개발로그필름

https://school.programmers.co.kr/learn/courses/30/lessons/298519 프로그래머스SW개발자를 위한 평가, 교육의 Total Solution을 제공하는 개발자 성장을 위한 베이스캠프programmers.co.kr 정답 쿼리SELECT COUNT(*) AS FISH_COUNT, MAX(LENGTH) AS MAX_LENGTH, FISH_TYPEFROM FISH_INFOGROUP BY FISH_TYPEHAVING AVG(IF(LENGTH IS NULL, 10, LENGTH)) >= 33ORDER BY FISH_TYPE; 오답 노트HAVING AVG(IF(LENGTH IS NULL, 10, LENGTH)) >= 33group by 조건문에서 계속 틀렸다문제에..

https://school.programmers.co.kr/learn/courses/30/lessons/131532 프로그래머스SW개발자를 위한 평가, 교육의 Total Solution을 제공하는 개발자 성장을 위한 베이스캠프programmers.co.kr 정답 쿼리SELECT YEAR(sales_date) YEAR, MONTH(sales_date) MONTH, GENDER, COUNT(DISTINCT I.USER_ID) USERSFROM USER_INFO IJOIN ONLINE_SALE S ON I.USER_ID = S.USER_IDWHERE GENDER IS NOT NULLGROUP BY YEAR(sales_date), MONTH(sales_date), GENDERORDE..

정답 쿼리SELECT CART_IDFROM CART_PRODUCTSWHERE NAME IN ('Milk', 'Yogurt')GROUP BY CART_IDHAVING COUNT(DISTINCT NAME) = 2ORDER BY CART_ID

https://school.programmers.co.kr/learn/courses/30/lessons/144856 정답 쿼리WITH JAN_SALE AS ( SELECT * FROM BOOK_SALES WHERE SALES_DATE LIKE '2022-01%'),AUTHOR_CAT_SALE AS ( SELECT A.AUTHOR_ID, A.AUTHOR_NAME, B.CATEGORY, SUM(J.SALES * B.PRICE) TOTAL_SALES FROM AUTHOR A JOIN BOOK B ON A.AUTHOR_ID = B.AUTHOR_ID JOIN JAN_SALE J ON B.BOOK_ID = J.BOOK_ID GROUP BY A.A..

정답 쿼리SELECT CAR_ID, CASE WHEN SUM(CASE WHEN '2022-10-16' BETWEEN START_DATE AND END_DATE THEN 1 ELSE 0 END) > 0 THEN '대여중' ELSE '대여 가능' END AS AVAILABILITYFROM CAR_RENTAL_COMPANY_RENTAL_HISTORYGROUP BY CAR_IDORDER BY CAR_ID DESC 오답 노트SUM(CASE WHEN '2022-10-16' BETWEEN START_DATE AND END_DATE THEN 1 ELSE 0 END) > 0CAR_RENTAL_COMPANY_RENTAL_HISTORY 테이블은 자동차 1대가 여러 번 대여될 수 있..

정답 쿼리WITH APNT_CNCL_N AS ( SELECT * FROM APPOINTMENT WHERE APNT_CNCL_YN = 'N' AND APNT_YMD LIKE '2022-04-13%' AND MCDP_CD = 'CS')SELECT N.APNT_NO, P.PT_NAME, P.PT_NO, N.MCDP_CD, D.DR_NAME, N.APNT_YMDFROM PATIENT PJOIN APNT_CNCL_N N ON P.PT_NO = N.PT_NOJOIN DOCTOR D ON N.MDDR_ID = D.DR_IDORDER BY N.APNT_YMD ASC

https://school.programmers.co.kr/learn/courses/30/lessons/164671 프로그래머스SW개발자를 위한 평가, 교육의 Total Solution을 제공하는 개발자 성장을 위한 베이스캠프programmers.co.kr 정답 쿼리SELECT CONCAT('/home/grep/src/', BOARD_ID, '/', FILE_ID, FILE_NAME, FILE_EXT) FILE_PATHFROM USED_GOODS_FILEWHERE BOARD_ID IN ( SELECT BOARD_ID FROM USED_GOODS_BOARD WHERE VIEWS = (SELECT MAX(VIEWS) FROM USED_GOODS_BOARD))ORDER BY FILE_PATH..

정답 쿼리SELECT I.ITEM_ID, I.ITEM_NAME, I.RARITYFROM ITEM_INFO ILEFT JOIN ITEM_TREE T ON I.ITEM_ID = T.PARENT_ITEM_IDWHERE T.PARENT_ITEM_ID IS NULLORDER BY I.ITEM_ID DESC