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

 

DATETIME에서 DATE로 형 변환

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

프로그래머스

SELECT ANIMAL_ID,
       NAME,
       DATE_FORMAT(DATETIME, '%Y-%m-%d') AS '날짜'
FROM   ANIMAL_INS
ORDER BY ANIMAL_ID ASC

 

가격이 제일 비싼 식품의 정보 출력하기

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

프로그래머스

SELECT PRODUCT_ID,
       PRODUCT_NAME,
       PRODUCT_CD,
       CATEGORY,
       PRICE
FROM   FOOD_PRODUCT
ORDER 
BY     PRICE DESC
LIMIT  1

SELECT *
FROM   FOOD_PRODUCT
WHERE  PRICE = (SELECT MAX(PRICE)
                FROM FOOD_PRODUCT)

 

3월에 태어난 여성 회원 목록 출력하기

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

프로그래머스

SELECT MEMBER_ID,
       MEMBER_NAME,
       GENDER,
       DATE_FORMAT(DATE_OF_BIRTH, '%Y-%m-%d') AS DATE_OF_BIRTH
FROM   MEMBER_PROFILE
WHERE  DATE_OF_BIRTH LIKE '%03%' AND GENDER = 'W' AND TLNO IS NOT NULL
ORDER 
BY     MEMBER_ID ASC

 

카테고리 별 상품 개수 구하기

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

프로그래머스

SELECT SUBSTR(PRODUCT_CODE,1,2) AS 'CATEGORY',
       COUNT(PRODUCT_CODE) AS 'PRODUCTS'
FROM   PRODUCT
GROUP
BY     SUBSTR(PRODUCT_CODE,1,2)
ORDER
BY     PRODUCT_CODE ASC

 

가격대 별 상품 개수 구하기

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

프로그래머스

SELECT TRUNCATE(PRICE,-4) AS PRICE_GROUP,
       COUNT(1) AS PRODUCTS
FROM   PRODUCT
GROUP
BY     PRICE_GROUP
ORDER
BY     PRICE_GROUP ASC