DATE_FORMAT2 programmers : 5월 식품들의 총매출 조회하기 5월 식품들의 총매출 조회하기 SELECT PRODUCT_ID, PRODUCT_NAME, SUM(FO.AMOUNT) * FP.PRICE TOTAL_SALES FROM FOOD_PRODUCT FP JOIN FOOD_ORDER FO USING (PRODUCT_ID) WHERE DATE_FORMAT(FO.PRODUCE_DATE, '%Y-%m') = '2022-05' GROUP BY PRODUCT_ID ORDER BY TOTAL_SALES DESC, PRODUCT_ID 2023. 1. 13. programmers : 조건에 맞는 도서와 저자 리스트 출력하기 USING / = SELECT BOOK_ID, AUTHOR_NAME, DATE_FORMAT(PUBLISHED_DATE, '%Y-%m-%d') PUBLISHED_DATE FROM BOOK JOIN AUTHOR USING(AUTHOR_ID) WHERE CATEGORY = '경제' ORDER BY PUBLISHED_DATE ; ON / LIKE SELECT BOOK_ID, AUTHOR_NAME, DATE_FORMAT(PUBLISHED_DATE, '%Y-%m-%d') PUBLISHED_DATE FROM BOOK B JOIN AUTHOR A ON B.AUTHOR_ID = A.AUTHOR_ID WHERE CATEGORY LIKE '%경제%' ORDER BY PUBLISHED_DATE ; 2023. 1. 12. 이전 1 다음