在BigQuery SQL中获取以前的工作周日期

WITH previous_week_dates AS (
  SELECT 
    DATE_SUB(CURRENT_DATE(), INTERVAL 1 WEEK) AS start_date,
    DATE_SUB(CURRENT_DATE(), INTERVAL 1 DAY) AS end_date
),
previous_week_days AS (
  SELECT 
    DATE(DATE_SUB(start_date, INTERVAL 1 DAY)) AS monday,
    DATE(DATE_SUB(start_date, INTERVAL 2 DAY)) AS tuesday,
    DATE(DATE_SUB(start_date, INTERVAL 3 DAY)) AS wednesday,
    DATE(DATE_SUB(start_date, INTERVAL 4 DAY)) AS thursday,
    DATE(DATE_SUB(start_date, INTERVAL 5 DAY)) AS friday,
    DATE(DATE_SUB(start_date, INTERVAL 6 DAY)) AS saturday,
    DATE(DATE_SUB(start_date, INTERVAL 7 DAY)) AS sunday
  FROM previous_week_dates
)
SELECT * FROM previous_week_days;