关于统计任务需求的算法设计

我现在有如图的数据库或者json
我想统计最后A B C D的数量改如何统计

(select name_1 as name_Sum,sum(name_1_c) as count from table group by name_1_c union select name_2,sum(name_2_c) from table group by name_2_c as table_new)
select name_Sum,sum(count) from table_new group by name_Sum

select name_Sum,sum(count) from (select name_1 as name_Sum,sum(name_1_c) as count from table group by name_1_c union select name_2,sum(name_2_c) from table group by name_2_c ) group by name_Sum

SELECT NAME, SUM(COUNT)
FROM (SELECT name_1 NAME, name_1_c COUNT
FROM tbl_name
UNION ALL
SELECT name_2 NAME, name_2_c COUNT
FROM tbl_name)
GROUP BY NAME

用最简单的方法就可以了公式直接套，希望可以帮你

本需求用union时记得要使用全并集，防止数据去重