happy coding

SELECT FLAVOR FROM FIRST_HALF ORDER BY TOTAL_ORDER DESC, SHIPMENT_ID ASC;

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

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

SELECT ICECREAM_INFO.FLAVOR FROM FIRST_HALF, ICECREAM_INFO INNER JOIN ICECREAM_INFO ON FIRST_HALF.FLAVOR = ICECREAM_INFO.FLAVOR WHERE FIRST_HALF.TOTAL_ORDER > 3000 AND ICECREAM_INFO.INGREDIENT_TYPE = 'fruit_based' ORDER BY FIRST_HALF.TOTAL_ORDER DESC; 틀렸다. SQL 실행 중 오류가 발생하였습니다. Not unique table/alias: 'ICECREAM_INFO' SELECT FIRST_HALF.FLAVOR FROM FIRST_HALF LEFT JOIN ICECREAM_INFO ON FIRST_HALF...

SELECT CAR_ID, CAR_TYPE, DAILY_FEE, OPTIONS FROM CAR_RENTAL_COMPANY_CAR WHERE OPTIONS LIKE '%네비게이션%' ORDER BY CAR_ID DESC;

SELECT HISTORY_ID, CAR_ID, DATE_FORMAT(START_DATE, '%Y-%m-%d') AS START_DATE, DATE_FORMAT(END_DATE, '%Y-%m-%d') AS END_DATE, CASE WHEN DATEDIFF(END_DATE,START_DATE) +1 >= 30 THEN '장기 대여' ELSE '단기 대여' END AS RENT_TYPE FROM CAR_RENTAL_COMPANY_RENTAL_HISTORY WHERE START_DATE LIKE '2022-09-%' ORDER BY HISTORY_ID DESC; case문 유의점 : 하루 동안 대여하고 반납해도 기간은 1일 반납하기 때문에 0 반례 해결해야 한다.

SELECT B.TITLE, B.BOARD_ID, R.REPLY_ID, R.WRITER_ID, R.CONTENTS, DATE_FORMAT(R.CREATED_DATE, '%Y-%m-%d') AS CREATED_DATE FROM USED_GOODS_BOARD AS B INNER JOIN USED_GOODS_REPLY AS R ON B.BOARD_ID = R.BOARD_ID WHERE B.CREATED_DATE LIKE '2022-10-%' ORDER BY R.CREATED_DATE ASC, B.TITLE ASC; 조인 잘 모르겠다. 그냥 여러 블로그 참고해서 최대한 해봤다. 왼쪽 조인으로 한 사람도 내부 조인 오른쪽 조인 다 있었는데, 처음에는 오른쪽 조인하다가 뭐가 문제인지 모르겠으나 내부 조인으로 하니까..

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