SQLite 3.8

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

WITH tble_1 AS (
    SELECT 'Doctor' AS Job, 'US' AS Site UNION ALL
    SELECT 'Doctor', 'Japan' UNION ALL
    SELECT 'Doctor', 'Germany' UNION ALL
    SELECT 'Artist', 'Mexico' UNION ALL
    SELECT 'Actor', 'Russia' UNION ALL
    SELECT 'Actor', 'India' UNION ALL
    SELECT 'Actor', 'Mexico'
),
tble_2 AS (
    SELECT 'Doctor' AS Job, 'US' AS Site UNION ALL
    SELECT 'Doctor', 'Japan' UNION ALL
    SELECT 'Doctor', 'Germany' UNION ALL
    SELECT 'Artist', 'Mexico' UNION ALL
    SELECT 'Actor', 'Russia' UNION ALL
    SELECT 'Actor', 'India' UNION ALL
    SELECT 'Doctor', 'Germany'
)

SELECT
    t1.Job,
    t1.Site,
    COALESCE(t3.HeadCount, 0) AS HeadCount,
    COALESCE(t2.SiteCount, 0) AS Total
FROM tble_1 t1
LEFT JOIN
(
    SELECT Job, COUNT(*) AS SiteCount
    FROM tble_1 
    GROUP BY Job
) t2
    ON t1.Job = t2.Job
LEFT JOIN
(
    SELECT A.Job, A.Site, COUNT(*) AS HeadCount
    FROM tble_1 A
    LEFT JOIN tble_2 B
        ON A.Job = B.Job AND A.Site = B.Site
    GROUP BY A.Job, A.Site
) t3
    ON t1.Job = t3.Job AND t1.Site = t3.Site;

Job	Site	HeadCount	Total
Doctor	US	1	3
Doctor	Japan	1	3
Doctor	Germany	2	3
Artist	Mexico	1	1
Actor	Russia	1	3
Actor	India	1	3
Actor	Mexico	1	3