Delete records from multiple tables in one query with CTE

delete_with_cte.sql

WITH
    first AS (
        DELETE FROM table1 WHERE condition1
            RETURNING *
    ),
    second AS (
        DELETE FROM table2 WHERE condition2
            RETURNING *
    ),
    -- add more analogous delete statements
    deleted_counts AS (
        SELECT
            (SELECT COUNT(*) FROM table1) AS count_table1,
            (SELECT COUNT(*) FROM table2) AS count_table2
    )
SELECT * FROM deleted_counts;