SQL공부 feat. 프로그래머스 (4) (CASE-WHEN-ELSE-END)

CASE WHEN ELSE END

중성화 여부 파악하기

링크: https://school.programmers.co.kr/learn/challenges?order=acceptance_desc&statuses=unsolved&levels=1%2C2&languages=mysql

-- 코드를 입력하세요
SELECT animal_id,
       NAME,
       ( CASE
           WHEN sex_upon_intake LIKE "neutered%"
                 OR sex_upon_intake LIKE "spayed%" THEN "o"
           ELSE "x"
         END ) AS 중성화
FROM   animal_ins
ORDER  BY animal_id;

조건에 부합하는 중고거래 상태 조회하기

링크: https://school.programmers.co.kr/learn/courses/30/lessons/164672

-- 코드를 입력하세요
SELECT board_id,
       writer_id,
       title,
       price,
       ( CASE
           WHEN status = "sale" THEN "판매중"
           WHEN status = "reserved" THEN "예약중"
           ELSE "거래완료"
         END ) AS STATUS
FROM   used_goods_board
WHERE  created_date = "2022-10-5"
ORDER  BY board_id DESC;

IN

루시와 엘라 찾기

링크: https://school.programmers.co.kr/learn/courses/30/lessons/59046

-- 코드를 입력하세요
SELECT animal_id,
       NAME,
       sex_upon_intake
FROM   animal_ins
WHERE  NAME IN ( "lucy", "ella", "pickle", "rogan",
                 "sabrina", "mitty" )
ORDER  BY animal_id;

자동차 평균 대여 기간 구하기

링크: https://school.programmers.co.kr/learn/courses/30/lessons/157342

-- 코드를 입력하세요
SELECT car_id,
       Round(Avg(Datediff(end_date, start_date) + 1), 1) AS AVERAGE_DURATION
FROM   car_rental_company_rental_history
WHERE  average_duration >= 6
GROUP  BY car_id
ORDER  BY average_duration DESC,
          car_id DESC;

 

---

LEVEL 2 끝!

29문제 밖에 안남았네..!