https://school.programmers.co.kr/learn/courses/30/lessons/133026 SELECT I.INGREDIENT_TYPE, SUM(H.TOTAL_ORDER) as TOTAL_ORDER FROM FIRST_HALF AS H JOIN ICECREAM_INFO AS I ON H.FLAVOR = I.FLAVOR GROUP BY I.INGREDIENT_TYPE ORDER BY TOTAL_ORDER JOIN ON GROUP BY SELECT + SUM
https://school.programmers.co.kr/learn/courses/30/lessons/132202 SELECT MCDP_CD as '진료과코드', count(*) as '5월예약건수' FROM APPOINTMENT WHERE YEAR(APNT_YMD)=2022 and MONTH(APNT_YMD)=5 GROUP BY MCDP_CD ORDER BY 5월예약건수, 진료과코드 WHERE DATE GROUP BY ORDER BY
https://school.programmers.co.kr/learn/courses/30/lessons/131115 [프로그래머스 코드 중심의 개발자 채용. 스택 기반의 포지션 매칭. 프로그래머스의 개발자 맞춤형 프로필을 등록하고, 나와 기술 궁합이 잘 맞는 기업들을 매칭 받으세요. programmers.co.kr](https://school.programmers.co.kr/learn/courses/30/lessons/131115) SELECT * FROM FOOD_PRODUCT WHERE PRICE IN (SELECT MAX(PRICE) AS P FROM FOOD_PRODUCT) MAX PRICE 찾기 WHERE IN
https://school.programmers.co.kr/learn/courses/30/lessons/131537 [프로그래머스 코드 중심의 개발자 채용. 스택 기반의 포지션 매칭. 프로그래머스의 개발자 맞춤형 프로필을 등록하고, 나와 기술 궁합이 잘 맞는 기업들을 매칭 받으세요. programmers.co.kr](https://school.programmers.co.kr/learn/courses/30/lessons/131537) SELECT DATE_FORMAT(SALES_DATE,'%Y-%m-%d') as SALES_DATE, PRODUCT_ID, USER_ID, SALES_AMOUNT FROM ONLINE_SALE WHERE YEAR(SALES_DATE) = 2022 AND MONT..
https://school.programmers.co.kr/learn/courses/30/lessons/131536 [프로그래머스 코드 중심의 개발자 채용. 스택 기반의 포지션 매칭. 프로그래머스의 개발자 맞춤형 프로필을 등록하고, 나와 기술 궁합이 잘 맞는 기업들을 매칭 받으세요. programmers.co.kr](https://school.programmers.co.kr/learn/courses/30/lessons/131536) SELECT USER_ID, PRODUCT_ID FROM ONLINE_SALE GROUP BY PRODUCT_ID, USER_ID HAVING COUNT(USER_ID)>=2 ORDER BY USER_ID, PRODUCT_ID DESC GROUP BY + HAVING 그룹화 ..
https://school.programmers.co.kr/learn/courses/30/lessons/131118 SELECT A.REST_ID, A.REST_NAME, A.FOOD_TYPE, A.FAVORITES, A.ADDRESS, ROUND(AVG(B.REVIEW_SCORE),2) AS SCORE FROM REST_INFO AS A JOIN REST_REVIEW AS B ON A.REST_ID = B.REST_ID WHERE A.ADDRESS like '서울%' GROUP BY A.REST_ID ORDER BY SCORE DESC, A.FAVORITES DESC JOIN WHERE like GROUP BY, 그룹 당 평균 점수 구하기 위해 ORDER BY ROUND( 값, 반올림 할 자릿수) 자리..
https://school.programmers.co.kr/learn/courses/30/lessons/132203 SELECT DR_NAME, DR_ID, MCDP_CD, DATE_FORMAT(HIRE_YMD,'%Y-%m-%d') FROM DOCTOR WHERE MCDP_CD = 'CS' or MCDP_CD = 'GS' ORDER BY HIRE_YMD DESC, DR_NAME WHERE ORDER BY SELECT + DATE_FORMAT
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 AGE
