WITH Atbl (gp_id, gp_nm) AS (
	SELECT 1, '서울' UNION ALL 
	SELECT 2, '인천'
), Btbl (ga_id, gp_id, ga_nm) AS (
	SELECT 1, 1, '강남' UNION ALL 
	SELECT 2, 1, '강북' UNION ALL 
	SELECT 3, 1, '논현' UNION ALL 
	SELECT 4, 2, '미추홀'
), Ctbl (sa_id, ga_id, sa_nm) AS (
	SELECT 1, 1, '입구' UNION ALL 
	SELECT 2, 1, '출구' UNION ALL 
	SELECT 3, 2, '입구' UNION ALL 
	SELECT 4, 3, '입구' 
), Dtbl (sp_id, sa_id, men, women, date) AS (
	SELECT 1, 1, 15, 25, '2022-01' UNION ALL 
	SELECT 2, 1, 10, 20, '2022-01' UNION ALL 
	SELECT 3, 2, 30, 45, '2022-02' UNION ALL 
	SELECT 4, 3, 50, 60, '2022-04' UNION ALL 
	SELECT 5, 4, 25, 30, '2022-03' UNION ALL
	SELECT 6, 4, 27, 47, '2022-05'
)

-- 결과에 Atbl 항목이 없어서 쿼리에서 Atbl 없어도 되긴하지만, 참고 쿼리라서 테이블을 다 포함은 시켰어요.
SELECT 
	Btbl.ga_id, Dtbl.date 
	, SUM(CASE WHEN Dtbl.sa_id = Ctbl.sa_id THEN Dtbl.men   ELSE 0 END) men
	, SUM(CASE WHEN Dtbl.sa_id = Ctbl.sa_id THEN Dtbl.women ELSE 0 END) women
FROM Atbl 
	INNER JOIN Btbl ON Atbl.gp_id = Btbl.gp_id
	INNER JOIN Ctbl ON Btbl.ga_id = Ctbl.ga_id
	CROSS JOIN Dtbl
WHERE Atbl.gp_id = 1 AND Dtbl.date BETWEEN '2022-01' AND '2022-04' -- AND Btbl.ga_id = 2 
GROUP BY Btbl.ga_id, Dtbl.date 
ORDER BY Btbl.ga_id, Dtbl.date 

WITH Atbl (gp_id, gp_nm) AS
(
SELECT 1, '서울' UNION ALL
SELECT 2, '인천'
)
, Btbl (ga_id, gp_id, ga_nm) AS
(
SELECT 1, 1, '강남' UNION ALL
SELECT 2, 1, '강북' UNION ALL
SELECT 3, 1, '논현' UNION ALL
SELECT 4, 2, '미추홀'
)
, Ctbl (sa_id, ga_id, sa_nm) AS
(
SELECT 1, 1, '입구' UNION ALL
SELECT 2, 1, '출구' UNION ALL
SELECT 3, 2, '입구' UNION ALL
SELECT 4, 3, '입구'
)
, Dtbl (sp_id, sa_id, men, women, date) AS
(
SELECT 1, 1, 15, 25, '2022-01' UNION ALL
SELECT 2, 1, 10, 20, '2022-01' UNION ALL
SELECT 3, 2, 30, 45, '2022-02' UNION ALL
SELECT 4, 3, 50, 60, '2022-04' UNION ALL
SELECT 5, 4, 25, 30, '2022-03' UNION ALL
SELECT 6, 4, 27, 47, '2022-05'
)
SELECT a.gp_id
     , a.gp_nm
     , b.ga_id
     , b.ga_nm
     , e.ym
     , IFNULL(SUM(d.men  ), 0) men
     , IFNULL(SUM(d.women), 0) women
  FROM Atbl a
 INNER JOIN Btbl b
    ON a.gp_id = b.gp_id
 CROSS JOIN
       (WITH RECURSIVE ym AS
        (
        SELECT '2022-01' ym
         UNION ALL
        SELECT DATE_FORMAT(DATE_ADD(CONCAT(ym, '-01'), INTERVAL 1 MONTH), '%Y-%m') ym
          FROM ym
         WHERE ym < '2022-04'
        )
        SELECT *
          FROM ym
       ) e
  LEFT OUTER JOIN Ctbl c
    ON b.ga_id = c.ga_id
  LEFT OUTER JOIN Dtbl d
    ON c.sa_id = d.sa_id
   AND e.ym = d.date
 WHERE a.gp_id = 1
 GROUP BY a.gp_id
     , a.gp_nm
     , b.ga_id
     , b.ga_nm
     , e.ym
;