WEEK

1
SELECT
2
  sale_date,
3
  WEEK(sale_date) as week_num,
4
  YEAR(sale_date) as year
5
FROM sales
6
WHERE sale_date >= '2024-01-01'
7
LIMIT 5;

1
SELECT
2
  YEAR(sale_date) as year,
3
  WEEK(sale_date) as week,
4
  SUM(amount) as weekly_sales,
5
  COUNT(*) as transaction_count
6
FROM sales
7
WHERE sale_date >= '2024-01-01'
8
GROUP BY YEAR(sale_date), WEEK(sale_date)
9
ORDER BY year, week;

1
WITH weekly AS (
2
  SELECT
3
    YEAR(sale_date) as year,
4
    WEEK(sale_date) as week,
5
    SUM(amount) as sales
6
  FROM sales
7
  GROUP BY 1, 2
8
)
9
SELECT
10
  year, week, sales,
11
  LAG(sales) OVER (ORDER BY year, week) as prev_week,
12
  ROUND((sales - LAG(sales) OVER (ORDER BY year, week)) * 100.0 /
13
    LAG(sales) OVER (ORDER BY year, week), 1) as wow_growth
14
FROM weekly;