Cacher is the code snippet organizer for pro developers

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