문제코드SELECT CAR_ID, MAX(CASE WHEN START_DATE ='2022-10-16' THEN '대여중' ELSE '대여 가능' END) AS AVAILABILITYFROM CAR_RENTAL_COMPANY_RENTAL_HISTORY group by CAR_IDORDER BY CAR_ID DESC; 출처: 프로그래머스 코딩 테스트 연습, https://school.programmers.co.kr/learn/courses/30/lessons/157340

문제코드SELECT AO.ANIMAL_ID, AO.NAMEFROM ANIMAL_INS AS AI RIGHT JOIN ANIMAL_OUTS AS AO ON AI.ANIMAL_ID = AO.ANIMAL_IDWHERE AI.INTAKE_CONDITION IS NULL; 출처: 프로그래머스 코딩 테스트 연습, https://school.programmers.co.kr/learn/courses/30/lessons/59042

문제코드SELECT ID, (CASE WHEN SIZE_OF_COLONY 출처: 프로그래머스 코딩 테스트 연습, https://school.programmers.co.kr/learn/courses/30/lessons/299307

문제코드SELECT UBU.USER_ID, UBU.NICKNAME, CONCAT(CITY, ' ', UBU.STREET_ADDRESS1, ' ', UBU.STREET_ADDRESS2) AS 전체주소, CONCAT(SUBSTRING(UBU.TLNO, 1, 3), '-', SUBSTRING(UBU.TLNO, 4, 4), '-', SUBSTRING(UBU.TLNO, 8, 4)) AS 전화번호FROM USED_GOODS_BOARD AS UGBJOIN USED_GOODS_USER AS UBU ON UGB.WRITER_ID = UBU.USER_IDGROUP BY UBU.USER_IDHAVING COUNT(UGB.BOARD_ID) >= 3OR..

문제코드SELECT HE.DEPT_ID, HD.DEPT_NAME_EN, ROUND(AVG(SAL),0) AS AVG_SALFROM HR_DEPARTMENT AS HD JOIN HR_EMPLOYEES AS HE ON HD.DEPT_ID = HE.DEPT_IDGROUP BY HE.DEPT_IDORDER BY AVG_SAL DESC; 출처: 프로그래머스 코딩 테스트 연습, https://school.programmers.co.kr/learn/courses/30/lessons/284529

문제코드SELECT RI.FOOD_TYPE, RI.REST_ID, RI.REST_NAME, RI.FAVORITESFROM REST_INFO RIJOIN ( SELECT FOOD_TYPE, MAX(FAVORITES) AS MAX_ FROM REST_INFO GROUP BY FOOD_TYPE) AS max_ON RI.FOOD_TYPE = max_.FOOD_TYPEAND RI.FAVORITES = max_.MAX_ORDER BY RI.FOOD_TYPE DESC; 출처: 프로그래머스 코딩 테스트 연습, https://school.programmers.co.kr/learn/courses/30/lessons/131123