프로그래머스 SQL 고득점 KIT - SELECT (LEVEL 1)

 

2023년 04월 16일 기준 (문제 업데이트 중)

조건에 맞는 회원수 구하기 (LEVEL 1)

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

프로그래머스

SELECT COUNT(user_id) as users
FROM user_info
WHERE YEAR(joined) = '2021' AND age >= 20 AND age <= 29;

상위 N개 레코드 (LEVEL 1)

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

프로그래머스

SELECT NAME 
FROM ANIMAL_INS 
ORDER BY DATETIME 
ASC LIMIT 1

여러 기준으로 정렬하기 (LEVEL 1)

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

프로그래머스

SELECT ANIMAL_ID, NAME, DATETIME 
FROM ANIMAL_INS
ORDER BY NAME ASC, DATETIME DESC

동물의 아이디와 이름 (LEVEL 1)

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

프로그래머스

SELECT ANIMAL_ID, NAME
FROM ANIMAL_INS
ORDER BY ANIMAL_ID ASC

어린 동물 찾기 (LEVEL 1)

https://school.programmers.co.kr/learn/courses/30/lessons/59037#fn1

프로그래머스

SELECT ANIMAL_ID, NAME
FROM ANIMAL_INS
WHERE INTAKE_CONDITION != 'Aged'
ORDER BY ANIMAL_ID

아픈 동물 찾기 (LEVEL 1)

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

프로그래머스

SELECT ANIMAL_ID, NAME
FROM ANIMAL_INS
WHERE INTAKE_CONDITION = 'Sick'
ORDER BY ANIMAL_ID

역순 정렬하기 (LEVEL 1)

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

프로그래머스

SELECT NAME, DATETIME
FROM ANIMAL_INS
ORDER BY ANIMAL_ID DESC

모든 레코드 조회하기 (LEVEL 1)

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

프로그래머스

SELECT *
FROM ANIMAL_INS
ORDER BY ANIMAL_ID;

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

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

조건에 맞는 도서리스트 출력하기 (LEVEL1)

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

프로그래머스

SELECT BOOK_ID, DATE_FORMAT(PUBLISHED_DATE, '%Y-%m-%d') AS PUSBLISHED_DATE
FROM BOOK
WHERE CATEGORY='인문' AND YEAR(PUBLISHED_DATE)='2021'
ORDER BY PUBLISHED_DATE;

 

조건에 부합하는 중고거래 댓글 조회하기 (LEVEL1)

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

프로그래머스

SELECT A.TITLE, A.BOARD_ID, B.REPLY_ID, B.WRITER_ID, B.CONTENTS, DATE_FORMAT(B.CREATED_DATE, '%Y-%m-%d')
FROM USED_GOODS_BOARD AS A
JOIN USED_GOODS_REPLY AS B
ON A.BOARD_ID=B.BOARD_ID
WHERE MONTH(A.CREATED_DATE)=10
ORDER BY B.CREATED_DATE, A.TITLE

인기있는 아이스크림 (LEVEL 1)

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

프로그래머스

SELECT FLAVOR
FROM FIRST_HALF
ORDER BY TOTAL_ORDER DESC, SHIPMENT_ID ASC

평균 일일 대여요금 구하기(LEVEL 1)

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

프로그래머스

SELECT ROUND(AVG(DAILY_FEE),0) AS AVERAGE_FEE
FROM CAR_RENTAL_COMPANY_CAR 
WHERE CAR_TYPE = "SUV"

흉부외과 또는 일반외과 의사목록 출력하기 (LEVEL 1)

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

프로그래머스

SELECT DR_NAME, DR_ID,MCDP_CD, DATE_FORMAT(HIRE_YMD, '%Y-%m-%d') AS HIRE_YMD
FROM DOCTOR
WHERE MCDP_CD = 'CS' OR MCDP_CD= 'GS'
ORDER BY HIRE_YMD DESC, DR_NAME ASC

12세 이하인 여자 환자 목록 출력하기 (LEVEL 1)

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

프로그래머스

SELECT PT_NAME, PT_NO, GEND_CD, AGE, IFNULL(TLNO, 'NONE') AS TLNO
FROM PATIENT
WHERE GEND_CD='W' AND AGE<=12
ORDER BY AGE DESC, PT_NAME ASC

과일로 만든 아이스크림 고르기 (LEVEL 1)

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

프로그래머스

SELECT A.FLAVOR
FROM FIRST_HALF AS A
JOIN ICECREAM_INFO AS B ON A.FLAVOR=B.FLAVOR
WHERE A.TOTAL_ORDER>3000 AND B.INGREDIENT_TYPE='fruit_based'
ORDER BY A.TOTAL_ORDER DESC