나만 알 수 없어서 만든 블로그

보호되어 있는 글입니다.

SELECT ANIMAL_ID, NAME, (CASE WHEN SEX_UPON_INTAKE LIKE "%Spayed%" THEN "O" WHEN SEX_UPON_INTAKE LIKE "%Neutered%" THEN "O" ELSE "X" END) AS 중성화 FROM ANIMAL_INS ORDER BY ANIMAL_ID AS *** 제에발 조회순서도 좀 봐라....

SELECT ANIMAL_ID, NAME FROM ANIMAL_INS WHERE NAME LIKE "%el%" AND ANIMAL_TYPE = "dog" ORDER BY NAME ASC

SELECT ANIMAL_ID, NAME, SEX_UPON_INTAKE FROM ANIMAL_INS WHERE NAME IN ('Lucy', 'Ella', 'Pickle', 'Rogan', 'Sabrina', 'Mitty')

SELECT A.ANIMAL_ID, A.ANIMAL_TYPE, A.NAME FROM ANIMAL_INS AS A JOIN ANIMAL_OUTS AS B ON A.ANIMAL_ID = B.ANIMAL_ID WHERE A.SEX_UPON_INTAKE != B.SEX_UPON_OUTCOME ORDER BY A.ANIMAL_ID 혼자 뻘짓을 많이 했다.... LIKE를 써서 비교하는 줄 알았는데 그냥 값이 다른지만 확인하는 것이었다

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

SELECT A.ANIMAL_ID, A.NAME AS OUTTIME FROM ANIMAL_INS AS A LEFT JOIN ANIMAL_OUTS AS B ON A.ANIMAL_ID = B.ANIMAL_ID WHERE A.DATETIME > B.DATETIME ORDER BY A.DATETIME ASC 보호 시작일이 빠른순으로 조회해야 한다는 점을 잊고 첫 시도는 실패했다.

SELECT A.ANIMAL_ID, A.NAME FROM ANIMAL_OUTS AS A LEFT JOIN ANIMAL_INS AS B ON A.ANIMAL_ID = B.ANIMAL_ID WHERE B.ANIMAL_TYPE IS NULL