WITH A AS (
SELECT
"route_id",
"client_id",
"sales_channel_id",
"sales_depot_id"
FROM "test_prepared"
),
B AS (
SELECT
"route_id",
"client_id",
"sales_channel_id",
"sales_depot_id"
FROM "train_prepared"
),
C AS (
SELECT * FROM A
UNION
SELECT * FROM B
),
D AS (
SELECT
"route_id", COUNT(*) FROM C
GROUP BY "route_id"
)
SELECT COUNT(*) FROM D
WITH A AS (
SELECT
"route_id",
"client_id",
"sales_channel_id",
"sales_depot_id"
FROM "test_prepared"
),
B AS (
SELECT
"route_id",
"client_id",
"sales_channel_id",
"sales_depot_id"
FROM "train_prepared"
),
C AS (
SELECT * FROM A
UNION
SELECT * FROM B
),
D AS (
SELECT
"sales_depot_id", COUNT(*) FROM C
GROUP BY "sales_depot_id"
)
SELECT COUNT(*) FROM D