[SQL 공부-프로그래머스] Lv.1 모음 - 2

 

12세 이하인 여자 환자 목록 출력하기

https://school.programmers.co.kr/learn/courses/30/lessons/132201

프로그래머스

 

SELECT PT_NAME, 
       PT_NO, 
       GEND_CD, 
       AGE,
       CASE WHEN TLNO IS NULL THEN 'NONE' ELSE TLNO END AS TLNO
FROM   PATIENT
WHERE  AGE <= 12 AND GEND_CD = 'W'
ORDER
BY     AGE DESC, PT_NAME ASC

 

가장 비싼 상품 구하기

https://school.programmers.co.kr/learn/courses/30/lessons/131697

프로그래머스

 

SELECT PRICE AS MAX_PRICE
FROM PRODUCT
ORDER BY PRICE DESC
LIMIT 1

 

조건에 맞는 회원수 구하기

https://school.programmers.co.kr/learn/courses/30/lessons/131535

프로그래머스

 

SELECT COUNT(*) AS USERS
FROM USER_INFO
WHERE SUBSTR(JOINED,1,4) = '2021' AND AGE >= 20 AND AGE <= 29

 

나이 정보가 없는 회원 수 구하기

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, 
       CASE WHEN FREEZER_YN IS NULL THEN 'N' ELSE FREEZER_YN END AS FREEZER_YN
FROM FOOD_WAREHOUSE
WHERE WAREHOUSE_NAME LIKE '%경기%'
ORDER BY WAREHOUSE_ID ASC

 

강원도에 위치한 생산공장 목록 출력하기

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 ASC