YEAR
MONTH
DAY
月を返します。
MONTH(date)
下記の値を入力するとサンプルに即時反映されます。
order_date
total_amount
revenue
orders
-- 월별 매출 집계 SELECT MONTH(order_date) AS month, SUM(total_amount) AS revenue FROM orders WHERE YEAR(order_date) = 2024 GROUP BY month;
