목록programmers (6)
개발세발
📍 [루시와 엘라 찾기] SELECT ANIMAL_ID, NAME, SEX_UPON_INTAKE FROM ANIMAL_INS WHERE NAME in('Lucy', 'Ella', 'Pickle', 'Rogan', 'Sabrina', 'Mitty'); 📍 [이름에 el이 들어가는 동물 찾기] SELECT ANIMAL_ID, NAME FROM ANIMAL_INS WHERE NAME LIKE "%EL%" AND ANIMAL_TYPE='DOG' ORDER BY NAME 📍 [중성화 여부 파악하기] SELECT ANIMAL_ID, NAME, CASE WHEN SEX_UPON_INTAKE LIKE 'Neutered%' THEN 'O' WHEN SEX_UPON_INTAKE LIKE 'SPAYED%' THEN 'O' ..
📍 [없어진 기록 찾기] 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..
📍 [이름이 없는 동물의 아이디] SELECT ANIMAL_ID FROM ANIMAL_INS WHERE NAME IS NULL order BY ANIMAL_ID; 📍 [이름이 있는 동물의 아이디] SELECT ANIMAL_ID FROM ANIMAL_INS WHERE NAME IS NOT NULL ORDER BY ANIMAL_ID; 📍 [NULL 처리하기] SELECT ANIMAL_TYPE, IFNULL(NAME, 'No name'), SEX_UPON_INTAKE FROM ANIMAL_INS
📍 [고양이와 개는 몇 마리 있을까] SELECT ANIMAL_TYPE, COUNT(*) AS count FROM ANIMAL_INS GROUP BY ANIMAL_TYPE order by animal_type 📍 [동명 동물 수 찾기] SELECT NAME, COUNT(*) FROM ANIMAL_INS WHERE NAME IS NOT NULL GROUP BY NAME HAVING COUNT(*)>1 ORDER BY NAME; 📍 [입양 시각 구하기(1)] SELECT HOUR(DATETIME) AS HOUR, COUNT(DATETIME) AS COUNT FROM animal_OUTS WHERE HOUR(DATETIME) >= 9 AND HOUR(DATETIME)