프로그래머스 - ORACLE SQL (String,Date)
루시와 엘라 찾기
SELECT animal_id, name, sex_upon_intake
FROM animal_ins
WHERE name='Lucy' or name='Ella' or name='Pickle' or name='Rogan' or name='Sabrina' or name='Mitty'
ORDER BY animal_id
이름에 el이들어가는 동물 찾기
SELECT animal_id, name
FROM animal_ins
WHERE (name Like '%el%' or name Like '%El%') and animal_type='Dog'
ORDER BY name
--UPPER(name) LIKE '%EL%'
중성화 여부 파악하기
SELECT animal_id, name, case
WHEN sex_upon_intake LIKE 'Neutered%' THEN 'O'
WHEN sex_upon_intake LIKE 'Spayed%' THEN 'O'
ELSE 'X'
END 중성화
FROM animal_ins
ORDER BY animal_id
오랜 기간 보호한 동물(2)
SELECT *
FROM
(SELECT i.animal_id, i.name
FROM animal_ins i
INNER JOIN animal_outs o
ON i.animal_id = o.animal_id
ORDER BY i.datetime-o.datetime)
WHERE ROWNUM<=2
DATETIME에서 DATE로 형 변환
SELECT animal_id, name, to_Char(datetime,'YYYY-MM-DD') 날짜
FROM animal_ins
ORDER BY animal_id