
๐ 1. ๋ฌธ์ ์ค๋ช

โญ 2. ์ ๋ต์ฝ๋
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;
๐ 3. TMI
ANSI SQL ํ์ค์์๋ ALIAS ์ ์์๋ฐ์ดํ๋ฅผ ์ฌ์ฉํ๋ ๊ฒ์ด ํ์ฉ๋์ง ์์ง๋ง ์จ๋ ์๊ด์ ์๋ค.
(๋๋ ๋ฐ์ดํ ์ผ์)
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;
'Algorithm > SQLํ ์คํธ' ์นดํ ๊ณ ๋ฆฌ์ ๋ค๋ฅธ ๊ธ

๐ 1. ๋ฌธ์ ์ค๋ช

โญ 2. ์ ๋ต์ฝ๋
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;
๐ 3. TMI
ANSI SQL ํ์ค์์๋ ALIAS ์ ์์๋ฐ์ดํ๋ฅผ ์ฌ์ฉํ๋ ๊ฒ์ด ํ์ฉ๋์ง ์์ง๋ง ์จ๋ ์๊ด์ ์๋ค.
(๋๋ ๋ฐ์ดํ ์ผ์)
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;