その日付が年の何週目かを返します。
構文
WEEK(date[, mode])使用例
下記の値を入力するとサンプルに即時反映されます。
order_date→week_no→total_amount→revenue→orders→-- 주차별 매출
SELECT WEEK(order_date) AS week_no, SUM(total_amount) AS revenue
FROM orders
GROUP BY week_no;
その日付が年の何週目かを返します。
WEEK(date[, mode])下記の値を入力するとサンプルに即時反映されます。
order_date→week_no→total_amount→revenue→orders→-- 주차별 매출
SELECT WEEK(order_date) AS week_no, SUM(total_amount) AS revenue
FROM orders
GROUP BY week_no;