#45. STRING, DATE : 중성화 여부 파악하기 | 프로그래머스 | SQL 고득점 Kit

문제 입력 코드 1. CASE SELECT ANIMAL_ID, NAME, (CASE WHEN SEX_UPON_INTAKE LIKE '%Neutered%' THEN 'O' WHEN SEX_UPON_INTAKE LIKE '%Spayed%' THEN 'O' ELSE 'X' END) AS '중성화' FROM ANIMAL_INS ORDER BY ANIMAL_ID; 2. IF SELECT ANIMAL_ID, NAME, IF(SEX_UPON_INTAKE LIKE '%NEUTERED%' OR SEX_UPON_INTAKE LIKE '%SPAYED%','O','X') AS '중성화' FROM ANIMAL_INS ORDER BY ANIMAL_ID ASC; 3. 정규식 SELECT ANIMAL_ID, NAME, IF(SEX_..

• format_list_bulleted SQL
• · 2023. 8. 11.
• textsms

#42. STRING, DATE : 조건에 부합하는 중고거래 상태 조회하기 | 프로그래머스 | SQL 고득점 Kit

문제 입력 코드 1. CASE SELECT BOARD_ID, WRITER_ID, TITLE, PRICE, (CASE WHEN STATUS ='SALE' THEN '판매중' WHEN STATUS ='RESERVED' THEN '예약중' WHEN STATUS ='DONE' THEN '거래완료' END) AS STATUS FROM USED_GOODS_BOARD WHERE CREATED_DATE = '2022-10-05' ORDER BY BOARD_ID DESC; 2. CASE - ELSE SELECT BOARD_ID, WRITER_ID, TITLE, PRICE, (CASE STATUS WHEN 'SALE' THEN '판매중' WHEN 'RESERVED' THEN '예약중' ELSE '거래완료' END) AS ..

• format_list_bulleted SQL
• · 2023. 8. 10.
• textsms