SQL两个日期之间的工作日

CREATE TABLE date_table (
    date_column DATE,
    is_weekday BOOLEAN
);

INSERT INTO date_table (date_column, is_weekday)
SELECT
    date_column,
    CASE WHEN DAYOFWEEK(date_column) IN (1, 7) THEN FALSE ELSE TRUE END AS is_weekday
FROM
    generate_series('2022-01-01'::date, '2022-12-31'::date, '1 day') AS date_column;

SELECT COUNT(*)
FROM date_table
WHERE date_column >= '2022-01-01'::date AND date_column <= '2022-12-31'::date AND is_weekday = TRUE;