코드의 나라에서의 일상

SELECT ANIMAL_TYPE, COUNT(ANIMAL_TYPE) AS "count" FROM ANIMAL_INS WHERE ANIMAL_TYPE IN ('Cat', 'Dog') GROUP BY ANIMAL_TYPE ORDER BY FIELD(ANIMAL_TYPE, 'Cat', 'Dog'); SELECT ANIMAL_TYPE, COUNT(ANIMAL_TYPE) AS "count" FROM ANIMAL_INS WHERE ANIMAL_TYPE IN ('Cat', 'Dog') GROUP BY ANIMAL_TYPE ORDER BY CASE ANIMAL_TYPE WHEN 'Cat' THEN 1 WHEN 'Dog' THEN 2 END;

SELECT HISTORY_ID, CAR_ID, DATE_FORMAT(START_DATE, '%Y-%m-%d') AS START_DATE, DATE_FORMAT(END_DATE, '%Y-%m-%d') AS END_DATE, CASE WHEN DATEDIFF(END_DATE, START_DATE) >= 29 THEN '장기 대여' ELSE '단기 대여' END AS RENT_TYPE FROM CAR_RENTAL_COMPANY_RENTAL_HISTORY WHERE START_DATE LIKE "2022-09-%" ORDER BY HISTORY_ID DESC; CASE 문은 주어진 조건에 따라 다른 값을 반환하는 조건부 표현식을 생성하는데 사용 CASE WHEN condition1 THEN result1 WH..