(programmers) SQL 문제풀이

아픈 동물 찾기
https://school.programmers.co.kr/learn/courses/30/lessons/59036

SELECT ANIMAL_ID, NAME from ANIMAL_INS
where INTAKE_CONDITION = 'Sick'

동물의 아이디와 이름
https://school.programmers.co.kr/learn/courses/30/lessons/59403

SELECT ANIMAL_ID, NAME from ANIMAL_INS
order by ANIMAL_ID

이름이 있는 동물의 아이디
https://school.programmers.co.kr/learn/courses/30/lessons/59407

SELECT ANIMAL_ID from ANIMAL_INS
where NAME is not null
order by ANIMAL_ID

상위 n개 레코드
https://school.programmers.co.kr/learn/courses/30/lessons/59405

SELECT name from animal_ins 
order by datetime limit 1

여러 기준으로 정렬하기
https://school.programmers.co.kr/learn/courses/30/lessons/59404

SELECT animal_id, name, datetime from animal_ins
order by name, datetime desc

어린 동물 찾기
https://school.programmers.co.kr/learn/courses/30/lessons/59037

SELECT animal_id, name from animal_ins
where intake_condition != 'Aged'
order by animal_id

역순 정렬하기
https://school.programmers.co.kr/learn/courses/30/lessons/59035

SELECT name, datetime from animal_ins
order by animal_id desc

강원도에 위치한 생산공장 목록 출력하기
https://school.programmers.co.kr/learn/courses/30/lessons/131112

SELECT factory_id, FACTORY_NAME, ADDRESS from FOOD_FACTORY
where address like '강원도%'
order by factory_id

나이 정보가 없는 회원 수 구하기
https://school.programmers.co.kr/learn/courses/30/lessons/131528

SELECT count(*) as USERS from user_info
where age is null

경기도에 위치한 식품창고 목록 출력하기
https://school.programmers.co.kr/learn/courses/30/lessons/131114

SELECT WAREHOUSE_ID,WAREHOUSE_NAME,ADDRESS, ifnull(FREEZER_YN, 'N') as FREEZER_YN  from FOOD_WAREHOUSE
where address like '경기도%'
order by WAREHOUSE_ID

조건에 맞는 회원수 구하기
https://school.programmers.co.kr/learn/courses/30/lessons/131535

SELECT count(*) as users from user_info
where (joined between '2021-01-01' and '2021-12-31') 
and (age between 19 and 29)

이름이 없는 동물의 아이디
https://school.programmers.co.kr/learn/courses/30/lessons/59039

SELECT animal_id from animal_ins
where name is null
order by animal_id