목록2023/10 (27)

Data Analyst KIM

[프로그래머스_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
데이터 분석/Coding Test 2023. 10. 16. 21:57
[프로그래머스_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_..
데이터 분석/Coding Test 2023. 10. 16. 21:53
[프로그래머스_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
데이터 분석/Coding Test 2023. 10. 16. 21:50
[프로그래머스_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
데이터 분석/Coding Test 2023. 10. 16. 21:47
[프로그래머스_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
데이터 분석/Coding Test 2023. 10. 16. 21:43
[프로그래머스_SQL] Lv3_오랜 기간 보호한 동물(1)

SELECT ai.NAME , ai.DATETIME FROM ANIMAL_INS AS ai LEFT JOIN ANIMAL_OUTS AS ao ON ai.ANIMAL_ID = ao.ANIMAL_ID WHERE ao.ANIMAL_ID IS NULL ORDER BY ai.DATETIME LIMIT 3
데이터 분석/Coding Test 2023. 10. 16. 21:39
이전 Prev 1 2 3 4 5 Next 다음