목록데이터 분석 (156)
Data Analyst KIM
[프로그래머스_SQL] Lv.3 - 조건별로 분류하여 주문상태 출력하기
SELECT ORDER_ID , PRODUCT_ID , DATE_FORMAT(OUT_DATE,'%Y-%m-%d') , CASE WHEN OUT_DATE '2022-05-01' THEN '출고대기' ELSE '출고미정' END '출고여부' FROM FOOD_ORDER ORDER BY ORDER_ID ASC
[프로그래머스_SQL] Lv3_조건에 맞는 사용자와 총 거래금액 조회하기
SELECT ugu.USER_ID , ugu.NICKNAME , SUM(ugb.PRICE) AS TOTAL_SALES FROM USED_GOODS_BOARD ugb INNER JOIN USED_GOODS_USER ugu ON ugb.WRITER_ID = ugu.USER_ID WHERE ugb.STATUS = 'DONE' GROUP BY ugu.USER_ID HAVING TOTAL_SALES >= 700000 ORDER BY TOTAL_SALES
[프로그래머스_SQL] Lv4_보호소에서 중성화한 동물
1. RIGHT JOIN 2. ai LIKE 'I%' AND ao NOT LKIE 'I%' SELECT ai.ANIMAL_ID , ai.ANIMAL_TYPE , ai.NAME FROM ANIMAL_INS ai RIGHT JOIN ANIMAL_OUTS ao ON ai.ANIMAL_ID = ao.ANIMAL_ID WHERE ai.SEX_UPON_INTAKE LIKE 'Intact%' AND ao.SEX_UPON_OUTCOME NOT LIKE 'Intact%' SELECT ai.ANIMAL_ID , ai.ANIMAL_TYPE , ai.NAME FROM ANIMAL_INS ai RIGHT JOIN ANIMAL_OUTS ao ON ai.ANIMAL_ID = ao.ANIMAL_ID WHERE ai.SEX_UPON_..
[프로그래머스_SQL] Lv3_오랜 기간 보호한 동물(2)
1. RIGHT JOIN 2. DATEDIFF 사용 후 내림차순 & LIMIT 2 SELECT ai.ANIMAL_ID , ai.NAME FROM ANIMAL_INS ai RIGHT JOIN ANIMAL_OUTS ao ON ai.ANIMAL_ID = ao.ANIMAL_ID ORDER BY DATEDIFF(ao.DATETIME, ai.DATETIME) DESC LIMIT 2
[프로그래머스_SQL] Lv3_있었는데요 없었습니다.
1. LEFT JOIN 2. ai.DATETIME > ao.DATETIME 3. ORDER BY SELECT ai.ANIMAL_ID , ai.NAME FROM ANIMAL_INS AS ai LEFT JOIN ANIMAL_OUTS AS ao ON ai.ANIMAL_ID = ao.ANIMAL_ID WHERE ai.DATETIME > ao.DATETIME ORDER BY ai.DATETIME
[프로그래머스_SQL] Lv3_카테고리 별 도서 판매량 집계하기
1. INNER JOIN 2. '2022-01' 데이터만 사용 3. SUM으로 총 판매량 계산 4. 카테고리 GROUP BY SELECT b.CATEGORY , SUM(bs.SALES) AS TOTAL_SALES FROM BOOK AS b INNER JOIN BOOK_SALES AS bs ON b.BOOK_ID = bs.BOOK_ID WHERE bs.SALES_DATE LIKE '2022-01%' GROUP BY b.CATEGORY