7daySQL 챌린지 Day 6

문제 출처: https://programmers.co.kr/events/7day-sql

7daySQL 챌린지 | 프로그래머스

문제 1

	SELECT
	NAME,
	DATETIME
	FROM
	ANIMAL_INS
	WHERE
	ANIMAL_ID
	NOT IN
	(
	SELECT
	ANIMAL_ID
	FROM
	ANIMAL_OUTS
	)
	ORDER BY
	DATETIME
	LIMIT
	3

view raw .sql hosted with ❤ by GitHub

문제 2

	SELECT
	ANIMAL_OUTS.ANIMAL_ID,
	ANIMAL_OUTS.ANIMAL_TYPE,
	ANIMAL_OUTS.NAME
	FROM
	ANIMAL_OUTS
	INNER JOIN
	ANIMAL_INS
	ON ANIMAL_OUTS.ANIMAL_ID = ANIMAL_INS.ANIMAL_ID
	WHERE
	ANIMAL_INS.SEX_UPON_INTAKE LIKE 'Intact%'
	AND
	(
	ANIMAL_OUTS.SEX_UPON_OUTCOME LIKE 'Spayed%'
	OR
	ANIMAL_OUTS.SEX_UPON_OUTCOME LIKE 'Neutered%'
	)
	ORDER BY
	ANIMAL_ID

view raw .sql hosted with ❤ by GitHub

지적, 조언, 질문 환영입니다! 댓글 남겨주세요~