문제 링크

없어진 기록 찾기

1
2
3
4
SELECT A.ANIMAL_ID, A.NAME
FROM ANIMAL_OUTS A LEFT JOIN ANIMAL_INS B ON A.ANIMAL_ID = B.ANIMAL_ID
WHERE B.ANIMAL_ID IS NULL
ORDER BY A.ANIMAL_ID

있었는데요 없었습니다

1
2
3
4
SELECT A.ANIMAL_ID, A.NAME
FROM ANIMAL_OUTS A LEFT JOIN ANIMAL_INS B ON A.ANIMAL_ID = B.ANIMAL_ID
WHERE A.DATETIME < B.DATETIME
ORDER BY B.DATETIME

오랜 기간 보호한 동물(1)

1
2
3
4
5
SELECT A.NAME, A.DATETIME
FROM ANIMAL_INS A LEFT JOIN ANIMAL_OUTS B ON A.ANIMAL_ID = B.ANIMAL_ID
WHERE B.ANIMAL_ID IS NULL
ORDER BY A.DATETIME
LIMIT 3

보호소에서 중성화한 동물

1
2
3
4
5
6
7
SELECT B.ANIMAL_ID, B.ANIMAL_TYPE, B.NAME
FROM ANIMAL_INS A LEFT JOIN ANIMAL_OUTS B ON A.ANIMAL_ID = B.ANIMAL_ID
WHERE
   (A.SEX_UPON_INTAKE = "Intact Male" OR A.SEX_UPON_INTAKE = "Intact Female") And
   (B.SEX_UPON_OUTCOME != "Intact Male" AND B.SEX_UPON_OUTCOME != "Intact Female")
ORDER BY B.ANIMAL_ID