https://school.programmers.co.kr/learn/courses/30/lessons/59037
https://school.programmers.co.kr/learn/courses/30/lessons/59038
https://school.programmers.co.kr/learn/courses/30/lessons/59041
https://school.programmers.co.kr/learn/courses/30/lessons/59047
https://school.programmers.co.kr/learn/courses/30/lessons/59406
#SQL Lv 1. 아픈동물찾기
SELECT ANIMAL_ID, NAME
FROM ANIMAL_INS
WHERE INTAKE_CONDITION = 'Sick';
# SQL Lv 1. 어린동물 찾기
SELECT ANIMAL_ID, NAME
FROM ANIMAL_INS
WHERE INTAKE_CONDITION != 'Aged'
ORDER BY ANIMAL_ID;
# SQL Lv 2. 최소값 구하기
SELECT MIN(DATETIME) AS 시간
FROM ANIMAL_INS;
# SQL Lv 2. 동물 수 구하기
SELECT COUNT(*)
FROM ANIMAL_INS;
# SQL Lv 2. 동명 동물 수 찾기
SELECT NAME, COUNT(NAME) AS 'COUNT'
FROM ANIMAL_INS
GROUP BY NAME
HAVING COUNT(NAME) > 1
ORDER BY NAME;
# SQL Lv 2. 이름에 el이 들어가는 동물 찾기
SELECT ANIMAL_ID, NAME
FROM ANIMAL_INS
WHERE ANIMAL_TYPE = 'Dog'
AND NAME LIKE "%EL%"
ORDER BY NAME;
'Algorithm > SQL' 카테고리의 다른 글
SQL 20240921 (0) | 2024.09.21 |
---|---|
SQL 20240919 (0) | 2024.09.19 |
SQL 20240918 (1) | 2024.09.18 |
SQL 20240917 (1) | 2024.09.17 |
SQL 20240915 (0) | 2024.09.15 |