[SQL 고득점 Kit] JOIN

 

📍 [없어진 기록 찾기] 

SELECT OUTS.ANIMAL_ID, OUTS.NAME 
FROM ANIMAL_INS INS RIGHT OUTER JOIN  ANIMAL_OUTS OUTS ON INS.ANIMAL_ID =OUTS.ANIMAL_ID
WHERE INS.ANIMAL_ID IS NULL 
ORDER BY OUTS.ANIMAL_ID

 

📍 [있었는데요 없었습니다] 

SELECT INS.ANIMAL_ID, INS.NAME 
FROM ANIMAL_INS INS LEFT JOIN ANIMAL_OUTS OUTS ON INS.ANIMAL_ID = OUTS.ANIMAL_ID 
WHERE INS.DATETIME > OUTS.DATETIME
ORDER BY INS.DATETIME;

 

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

SELECT INS.NAME, INS.DATETIME 
FROM ANIMAL_INS INS LEFT JOIN ANIMAL_OUTS OUTS ON INS.ANIMAL_ID = OUTS.ANIMAL_ID 
WHERE OUTS.ANIMAL_ID IS NULL 
ORDER BY INS.DATETIME
LIMIT 3;

 

📍 [보호소에서 중성화한 동물] 

SELECT INS.ANIMAL_ID, INS.ANIMAL_TYPE, INS.NAME
FROM ANIMAL_INS INS RIGHT JOIN ANIMAL_OUTS OUTS ON INS.ANIMAL_ID= OUTS.ANIMAL_ID
WHERE INS.SEX_UPON_INTAKE != OUTS.SEX_UPON_OUTCOME
ORDER BY INS.ANIMAL_ID