PROGRAMMING PROGRAMMING

PROGRAMMERS/SQL

• [프로그래머스] [MySQL] [Level 4] [GROUP BY] 년, 월, 성별 별 상품 구매 회원 수 구하기

  PROGRAMMERS/SQL 2022. 10. 23. 23:49

  문제 설명 예시 -- 코드를 입력하세요 SELECT YEAR(A.SALES_DATE) AS YEAR, MONTH(A.SALES_DATE) AS MONTH, B.GENDER, COUNT(DISTINCT B.USER_ID) AS USERS FROM ONLINE_SALE A JOIN USER_INFO B ON A.USER_ID = B.USER_ID WHERE GENDER IS NOT NULL GROUP BY YEAR, MONTH, B.GENDER ORDER BY YEAR, MONTH, B.GENDER

  Read More
• [프로그래머스] [MySQL] [Level 2] [SELECT] 재구매가 일어난 상품과 회원 리스트 구하기

  PROGRAMMERS/SQL 2022. 10. 23. 20:50

  문제 설명 예시 -- 코드를 입력하세요 SELECT USER_ID,PRODUCT_ID FROM ONLINE_SALE GROUP BY USER_ID,PRODUCT_ID HAVING COUNT(*)>=2 ORDER BY USER_ID,PRODUCT_ID DESC;

  Read More
• [프로그래머스] [MySQL] [Level 2] [GROUP BY] 진료과별 총 예약 횟수 출력하기

  PROGRAMMERS/SQL 2022. 10. 23. 20:44

  문제 설명 예시 -- 코드를 입력하세요 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월예약건수, 진료과코드;

  Read More
• [프로그래머스] [MySQL] [Level 1] [SELECT] 12세 이하인 여자 환자 목록 출력하기

  PROGRAMMERS/SQL 2022. 10. 23. 20:38

  문제 설명 예시 -- 코드를 입력하세요 SELECT PT_NAME, PT_NO, GEND_CD, AGE, CASE WHEN TLNO IS NULL THEN 'NONE' ELSE TLNO END AS TLNO FROM PATIENT WHERE AGE

  Read More
• [프로그래머스] [MySQL] [Level 1] [SELECT] 흉부외과 또는 일반외과 의사 목록 출력하기

  PROGRAMMERS/SQL 2022. 10. 23. 20:30

  문제 설명 예시 -- 코드를 입력하세요 SELECT DR_NAME, DR_ID, MCDP_CD, DATE_FORMAT(HIRE_YMD,"%Y-%m-%d") AS HIRE_YMD FROM DOCTOR WHERE MCDP_CD IN ("CS", "GS") ORDER BY HIRE_YMD DESC, DR_NAME;

  Read More
• [프로그래머스] [MySQL] [Level 2] [JOIN] 상품 별 오프라인 매출 구하기

  PROGRAMMERS/SQL 2022. 10. 14. 01:57

  SELECT P.PRODUCT_CODE, (PRICE * AMOUNT) AS SALES FROM PRODUCT P JOIN ( SELECT PRODUCT_ID, SUM(SALES_AMOUNT) AS AMOUNT FROM OFFLINE_SALE GROUP BY PRODUCT_ID ) S ON P.PRODUCT_ID = S.PRODUCT_ID ORDER BY SALES DESC, PRODUCT_CODE;

  Read More
• [프로그래머스] [MySQL] [Level 4] [SELECT] 서울에 위치한 식당 목록 출력하기

  PROGRAMMERS/SQL 2022. 10. 14. 01:37

  SELECT A.REST_ID, A.REST_NAME, A.FOOD_TYPE, A.FAVORITES, A.ADDRESS, ROUND(AVG(REVIEW_SCORE),2) AS SCORE FROM REST_INFO AS A LEFT JOIN REST_REVIEW AS B ON A.REST_ID = B.REST_ID WHERE A.ADDRESS LIKE '서울%' AND REVIEW_SCORE IS NOT NULL GROUP BY A.REST_ID ORDER BY SCORE DESC, A.FAVORITES DESC;

  Read More
• [프로그래머스] [MySQL] [Level 4] [JOIN] 5월 식품들의 총매출 조회하기

  PROGRAMMERS/SQL 2022. 10. 14. 00:57

  -- 코드를 입력하세요 SELECT A.PRODUCT_ID, A.PRODUCT_NAME , SUM(A.PRICE * B.AMOUNT) AS TOTAL_SALES FROM FOOD_PRODUCT AS A LEFT JOIN FOOD_ORDER AS B ON A.PRODUCT_ID = B.PRODUCT_ID WHERE YEAR(B.PRODUCE_DATE) = 2022 AND MONTH(B.PRODUCE_DATE) = 5 GROUP BY PRODUCT_NAME ORDER BY TOTAL_SALES DESC, A.PRODUCT_ID

  Read More