리스트 예시: 게시물이 존재할 경우 3건을 노출합니다.
- [SQL] LEETCODE SQL 50 문제풀이 1193. Monthly Transactions Ihttps://leetcode.com/problems/monthly-transactions-i/description/?envType=study-plan-v2&envId=top-sql-50SELECT DATE_FORMAT(trans_date, '%Y-%m') AS month, country, COUNT(id) AS trans_count, SUM(state = 'approved') AS approved_count, SUM(amount) AS trans_total_amount, SUM(IF(state = 'approved', amount, 0)) AS approved_total_amountFROM TransactionsGR.. 2025.03.06
- [SQL] 프로그래머스 고득점 Kit GROUP BY https://school.programmers.co.kr/learn/courses/30/parts/17044GROUP BY MIN/MAXWITH F_TYPE AS ( SELECT FOOD_TYPE, MAX(FAVORITES) AS FAVORITES FROM REST_INFO GROUP BY FOOD_TYPE)SELECT A.FOOD_TYPE, A.REST_ID, A.REST_NAME, A.FAVORITESFROM REST_INFO AS AJOIN F_TYPE AS B ON A.FOOD_TYPE = B.FOOD_TYPE AND A.FAVORITES = B.FAVORITESORDER BY FOOD_TYPE DESC집계 함수로 MIN/MAX를 사용할 때 해당 컬럼과 관련 없는 컬럼을 S.. 2025.02.17
- [SQL] 프로그래머스 고득점 Kit SELECT https://school.programmers.co.kr/learn/courses/30/parts/17042 GROUP BYSELECT 문에 있는 모든 열은 집계 함수가 되거나 GROUP BY절에 나타나야 함NTILE & CASEhttps://school.programmers.co.kr/learn/courses/30/lessons/301649?language=mysqlSELECT ID, CASE WHEN NR = '1' THEN 'CRITICAL' WHEN NR = '2' THEN 'HIGH' WHEN NR = '3' THEN 'MEDIUM' WHEN NR = '4' THEN 'LOW' END AS COLONY_NAMEFROM ( SE.. 2025.02.15