MySQL 8.0

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

WITH regions AS (
    SELECT 1 AS id, 'NY' AS name UNION ALL
    SELECT 2, 'Paris' UNION ALL
    SELECT 3, 'London'
),
restaunts AS (
    SELECT 1 AS id, 'kFC' AS name, 1 AS region_id UNION ALL
    SELECT 2, 'McDonals', 2
),
banner_ads AS (
    SELECT 1 AS id, '1.jpg' AS image, 500 AS fee, 1 AS region_id UNION ALL
    SELECT 2, '2.jpg', 500, 1 UNION ALL
    SELECT 3, '3.jpg', 500, 2 UNION ALL
    SELECT 4, '4.jpg', 500, 3
),
cuisine_promotions AS (
    SELECT 1 AS id, 1 AS cuisine_id, 500 AS fee, 1 AS region_id UNION ALL
    SELECT 2, 2, 500, 1 UNION ALL
    SELECT 3, 3, 500, 2 UNION ALL
    SELECT 4, 4, 500, 3
),
sponsored_promotions AS (
    SELECT 1 AS id, 1 AS item_id, 500 AS fee, 1 AS restaurant_id UNION ALL
    SELECT 2, 2, 500, 1 UNION ALL
    SELECT 3, 3, 500, 2 UNION ALL
    SELECT 4, 4, 500, 2
)

SELECT
    r.name,
    COALESCE(b.banner_revenue, 0) AS banner_revenue,
    COALESCE(c.cuisine_revenue, 0) AS cuisine_revenue,
    COALESCE(p.promotions_revenue, 0) AS promotions_revenue,
    COALESCE(b.banner_revenue, 0) + COALESCE(c.cuisine_revenue, 0) +
        COALESCE(p.promotions_revenue, 0) AS total
FROM regions r
LEFT JOIN
(
    SELECT region_id, SUM(fee) AS banner_revenue
    FROM banner_ads
    GROUP BY region_id
) b
    ON r.id = b.region_id
LEFT JOIN
(
    SELECT region_id, SUM(fee) AS cuisine_revenue
    FROM cuisine_promotions
    GROUP BY region_id
) c
    ON r.id = c.region_id
LEFT JOIN
(
    SELECT r.region_id, SUM(s.fee) AS promotions_revenue
    FROM restaunts r
    INNER JOIN sponsored_promotions s
        ON r.id = s.restaurant_id
    GROUP BY r.region_id
) p
    ON r.id = p.region_id;

name	banner_revenue	cuisine_revenue	promotions_revenue	total
NY	1000	1000	1000	3000
Paris	500	500	1000	2000
London	500	500	0	1000