728x90
SELECT
평균 일일 대여 요금 구하기 LV 1
SELECT ROUND(AVG(DAILY_FEE), 0) AS AVERAGE_FEE
FROM CAR_RENTAL_COMPANY_CAR
WHERE CAR_TYPE = 'SUV';
조건에 맞는 도서 리스트 출력 LV 1
SELECT BOOK_ID, DATE_FORMAT(PUBLISHED_DATE, '%Y-%m-%d') AS PUBLISHED_DATE
FROM BOOK
WHERE year(PUBLISHED_DATE) = 2021
AND CATEGORY = '인문'
ORDER BY PUBLISHED_DATE
조건에 부합하는 중고거래 댓글 조회 LV 1
SELECT TITLE, B.BOARD_ID, REPLY_ID, R.WRITER_ID,
R.CONTENTS, DATE_FORMAT(R.CREATED_DATE, '%Y-%m-%d')
FROM USED_GOODS_BOARD AS B INNER JOIN USED_GOODS_REPLY AS R
ON B.BOARD_ID = R.BOARD_ID
WHERE YEAR(B.CREATED_DATE) = 2022 AND MONTH(B.CREATED_DATE) = 10
ORDER BY R.CREATED_DATE, TITLE
3월에 태어난 여성 회원 목록 출력하기 LV 2
SELECT MEMBER_ID, MEMBER_NAME, GENDER,
DATE_FORMAT(DATE_OF_BIRTH, '%Y-%m-%d') AS DATE_OF_BIRTH
FROM MEMBER_PROFILE
WHERE GENDER = 'W' AND
MONTH(DATE_OF_BIRTH) = 3 AND
TLNO IS NOT NULL
흉부외과 또는 일반외과 의사 목록 출력하기 LV 1
SELECT DR_NAME, DR_ID, MCDP_CD, DATE_FORMAT(HIRE_YMD, '%Y-%m-%d')
FROM DOCTOR
WHERE MCDP_CD IN ('CS', 'GS')
ORDER BY HIRE_YMD DESC, DR_NAME
과일로 만든 아이스크림 고르기 LV 1
SELECT F.FLAVOR
FROM FIRST_HALF AS F INNER JOIN ICECREAM_INFO AS I
ON F.FLAVOR = I.FLAVOR
WHERE TOTAL_ORDER > 3000 AND INGREDIENT_TYPE = 'fruit_based'
ORDER BY TOTAL_ORDER DESC
인기 있는 아이스크림 LV 1
SELECT FLAVOR
FROM FIRST_HALF
ORDER BY TOTAL_ORDER DESC, SHIPMENT_ID
강원도에 위치한 생상공장 목록 출력하기 LV 1
SELECT FACTORY_ID, FACTORY_NAME, ADDRESS
FROM FOOD_FACTORY
WHERE ADDRESS LIKE '%강원도%'
ORDER BY FACTORY_ID
12세 이하인 여자 환자 목록 출력하기 LV 1
SELECT PT_NAME, PT_NO, GEND_CD, AGE, IF(TLNO, TLNO, 'NONE')
FROM PATIENT
WHERE AGE <= 12 AND GEND_CD = 'W'
ORDER BY AGE DESC, PT_NAME
서울에 위치한 식당 목록 출력하기 LV 4
SELECT REST_ID, REST_NAME, FOOD_TYPE, FAVORITES,
ADDRESS, ROUND(AVG(REVIEW_SCORE), 2) AS SCORE
FROM REST_INFO INNER JOIN REST_REVIEW USING (REST_ID)
GROUP BY REST_ID
HAVING ADDRESS LIKE '서울%'
ORDER BY SCORE DESC, FAVORITES DESC
재구매가 일어난 상품과 회원 리스트 구하기 LV 2
SELECT USER_ID, PRODUCT_ID
FROM ONLINE_SALE
GROUP BY USER_ID, PRODUCT_ID
HAVING COUNT(*) > 1
ORDER BY USER_ID, PRODUCT_ID DESC
728x90