DATE_SUB

1
SELECT
2
  CURRENT_DATE as today,
3
  CURRENT_DATE - INTERVAL '7 days' as last_week,
4
  CURRENT_DATE - INTERVAL '30 days' as last_month;

1
SELECT *
2
FROM orders
3
WHERE order_date >= CURRENT_DATE - INTERVAL '7 days';

1
SELECT
2
  COUNT(*) as total_orders,
3
  SUM(amount) as total_revenue
4
FROM orders
5
WHERE order_date >= DATE_TRUNC('month', CURRENT_DATE) - INTERVAL '1 month'
6
  AND order_date < DATE_TRUNC('month', CURRENT_DATE);

1
SELECT
2
  order_date,
3
  COUNT(*) as daily_orders
4
FROM orders
5
WHERE order_date >= CURRENT_DATE - INTERVAL '14 days'
6
GROUP BY order_date
7
ORDER BY order_date;