금마 일기

SELECT NAME, COUNT(NAME) AS 'COUNT' FROM ANIMAL_INS WHERE NAME IS NOT NULL GROUP BY NAME HAVING COUNT(NAME) >= 2 ORDER BY NAME

[해답] SELECT A.ANIMAL_ID, A.NAME FROM ANIMAL_INS A, ANIMAL_OUTS B WHERE A.ANIMAL_ID = B.ANIMAL_ID ORDER BY DATEDIFF(B.DATETIME, A.DATETIME) DESC LIMIT 2 DATEDIFF : 두 개의 날짜 값의 차이를 int로 반환하는 내장 함수이다. > 형식 : DATEDIFF('시작날짜', '끝 날짜') TIMESTAMPDIFF : DATEDIFF랑 비슷한 기능 > 형식 : TIMESTAMPDIFF('단위', '날짜 1', '날짜 2') 단위 => SECOND, MINUTE, HOUR, DAY, WEEK, MONTH, QUARTER, YEAR

[해답] SELECT A.ANIMAL_ID, A.ANIMAL_TYPE, A.NAME FROM ANIMAL_INS A, ANIMAL_OUTS B WHERE A.ANIMAL_ID = B.ANIMAL_ID AND A.SEX_UPON_INTAKE != B.SEX_UPON_OUTCOME ORDER BY A.ANIMAL_ID ASC

[해답] SELECT A.NAME, A.DATETIME FROM ANIMAL_INS A WHERE A.ANIMAL_ID NOT IN (SELECT B.ANIMAL_ID FROM ANIMAL_OUTS B) ORDER BY A.DATETIME ASC LIMIT 3 LIMIT : 출력 개수 조정할 때 쓴다

[해답] SELECT A.ANIMAL_ID, A.NAME FROM ANIMAL_INS A, ANIMAL_OUTS B WHERE A.ANIMAL_ID = B.ANIMAL_ID AND A.DATETIME > B.DATETIME ORDER BY A.DATETIME