프로그래머스 - 1단계 - MySQL

모든 레코드 조회하기

SELECT ANIMAL_ID, ANIMAL_TYPE, DATETIME, INTAKE_CONDITION, name, sex_upon_intake
from animal_ins
order by animal_id asc;

 

---

역순 정렬하기

SELECT name, datetime
from animal_ins
order by animal_id desc;

 

---

아픈 동물 찾기

SELECT animal_id, name
from animal_ins
where intake_condition='Sick'

 

---

어린 동물 찾기

select animal_id, name
from animal_ins
where intake_condition !='aged'

 

---

여러 기준으로 정렬하기

select animal_id, name, datetime
from animal_ins
order by name asc, datetime desc;

---

상위 n개 레코드

select name
from animal_ins
where datetime = 
        (select min(datetime) 
         from animal_ins)

---

중복 제거하기

select count(distinct name) as count
from animal_ins
where name is not null

 

 

---

고양이와 개는 몇 마리 있을까

select animal_type, count(animal_type) as count
from animal_ins
group by animal_type
order by animal_type

---

동명 동물 수 찾기

select name, count(name) as count
from animal_ins
group by name
having count(name)>1
order by name