목록2023/10/22 (3)

Data Analyst KIM

[SQL] 취소되지 않은 진료 예약 조회하기(프로그래머스)

SELECT a.APNT_NO , p.PT_NAME , a.PT_NO , a.MCDP_CD , d.DR_NAME , a.APNT_YMD FROM APPOINTMENT AS a INNER JOIN PATIENT AS p ON a.PT_NO = p.PT_NO INNER JOIN DOCTOR AS d ON a.MDDR_ID = d.DR_ID WHERE a.APNT_YMD LIKE '2022-04-13%' AND a.APNT_CNCL_YN = 'N' AND a.MCDP_CD ='CS' ORDER BY APNT_YMD
데이터 분석/Coding Test 2023. 10. 22. 11:58
[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
이전 Prev 1 Next 다음