목록데이터 분석 (145)

Data Analyst KIM

[SQL] 자동차 대여 기록에서 대여중 / 대여 가능 여부 구분하기(프로그래머스)

SELECT CAR_ID , CASE WHEN CAR_ID IN (SELECT CAR_ID FROM CAR_RENTAL_COMPANY_RENTAL_HISTORY WHERE '2022-10-16' BETWEEN START_DATE AND END_DATE) THEN '대여중' ELSE '대여 가능' END 'AVAILABILITY' FROM CAR_RENTAL_COMPANY_RENTAL_HISTORY AS C GROUP BY CAR_ID ORDER BY CAR_ID DESC
데이터 분석/Coding Test 2023. 10. 22. 11:41
[SQL] 조건에 맞는 사용자 정보 조회하기(프로그래머스)

SELECT b.USER_ID , b.NICKNAME , CONCAT(CITY,' ',STREET_ADDRESS1,' ',STREET_ADDRESS2) AS '전체주소' , CONCAT(SUBSTRING(b.TLNO,1,3),'-',SUBSTRING(b.TLNO,4,4),'-',(SUBSTRING(b.TLNO,8,4))) AS '전화번호' FROM USED_GOODS_BOARD AS a INNER JOIN USED_GOODS_USER AS b ON a.WRITER_ID = b.USER_ID GROUP BY b.USER_ID HAVING COUNT(a.WRITER_ID) >= 3 ORDER BY b.USER_ID DESC
데이터 분석/Coding Test 2023. 10. 22. 11:24
[프로그래머스_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 2023. 10. 18. 22:09
[프로그래머스_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
이전 Prev 1 ··· 4 5 6 7 8 9 10 ··· 25 Next 다음