๋ฐ์ํ
https://school.programmers.co.kr/learn/courses/30/lessons/59045
๋ณดํธ์์ ๋ค์ด์ฌ ๋น์์๋ ์ค์ฑํ๋์ง ์์์ง๋ง, ๋ณดํธ์๋ฅผ ๋๊ฐ ๋น์์๋ ์ค์ฑํ๋
๋๋ฌผ์ ์์ด๋์ ์๋ฌผ ์ข , ์ด๋ฆ์ ์กฐํํ๋
์์ด๋ ์์ผ๋ก ์กฐํํ๋ SQL ๋ฌธ์ ์์ฑํด์ฃผ์ธ์.
-- ์ฝ๋๋ฅผ ์
๋ ฅํ์ธ์
SELECT i.animal_id, i.animal_type, i.name
from animal_ins i join animal_outs o on i.animal_id = o.animal_id
where i.sex_upon_intake like "Intact%" and o.sex_upon_outcome not like "Intact%"
order by i.animal_id
๋ฐ์ํ