Programmersで中性化した動物を保護/20317


https://programmers.co.kr/learn/courses/30/lessons/59045

SQL

SELECT      A.ANIMAL_ID, A.ANIMAL_TYPE, A.NAME 
FROM 		ANIMAL_INS A 
INNER JOIN  ANIMAL_OUTS B 
ON 			B.ANIMAL_ID = A.ANIMAL_ID
WHERE 		A.SEX_UPON_INTAKE != B.SEX_UPON_OUTCOME
ORDER BY 	ANIMAL_ID
ANIMAL INSのSEX UPON INTAKEエントリと
ANIMAL OUTSのSEX UPON OUTCOMEエントリが異なる場合、出力