20240922===========================================
-- SQL Lv 2. 고양이와 개는 몇 마리 있을까
SELECT ANIMAL_TYPE,COUNT(*) AS "count"
FROM ANIMAL_INS
GROUP BY ANIMAL_TYPE
ORDER BY ANIMAL_TYPE;
-- SQL Lv 2. 중성화 여부 파악하기
SELECT ANIMAL_ID,NAME,
CASE WHEN SEX_UPON_INTAKE LIKE '%Neutered%' THEN 'O'
WHEN SEX_UPON_INTAKE LIKE '%Spayed%' THEN 'O'
ELSE 'X' END
AS "중성화"
FROM ANIMAL_INS
ORDER BY ANIMAL_ID;
-- SQL Lv 2. 입양 시각 구하기(1)
SELECT TO_NUMBER(TO_CHAR(DATETIME,'HH24')) AS HOUR,COUNT(*) AS COUNT
FROM ANIMAL_OUTS
WHERE TO_CHAR(DATETIME,'HH24') BETWEEN 9 AND 19
GROUP BY TO_CHAR(DATETIME,'HH24')
ORDER BY HOUR;
'Algorithm > SQL' 카테고리의 다른 글
SQL 20240929 (4) | 2024.09.30 |
---|---|
SQL 20240924 (2) | 2024.09.24 |
SQL 20240921 (0) | 2024.09.21 |
SQL 20240919 (0) | 2024.09.19 |
SQL 20240918 (1) | 2024.09.18 |