QUARTER

1
SELECT
2
  date_val,
3
  QUARTER(date_val) as quarter,
4
  'Q' || QUARTER(date_val) as quarter_label
5
FROM (
6
  SELECT DATE '2024-02-15' as date_val UNION ALL
7
  SELECT DATE '2024-05-20' UNION ALL
8
  SELECT DATE '2024-08-10' UNION ALL
9
  SELECT DATE '2024-11-25'
10
);

1
SELECT
2
  YEAR(invoice_date) as year,
3
  QUARTER(invoice_date) as quarter,
4
  SUM(amount) as revenue,
5
  COUNT(*) as invoice_count
6
FROM invoices
7
GROUP BY YEAR(invoice_date), QUARTER(invoice_date)
8
ORDER BY year, quarter;

1
WITH quarterly AS (
2
  SELECT
3
    YEAR(sale_date) || '-Q' || QUARTER(sale_date) as period,
4
    SUM(amount) as revenue
5
  FROM sales
6
  GROUP BY YEAR(sale_date), QUARTER(sale_date)
7
)
8
SELECT
9
  period,
10
  revenue,
11
  LAG(revenue) OVER (ORDER BY period) as prev_quarter,
12
  ROUND((revenue - LAG(revenue) OVER (ORDER BY period)) * 100.0 /
13
    LAG(revenue) OVER (ORDER BY period), 1) as qoq_growth
14
FROM quarterly;