如果你只需要总数，你可以直接把它加起来：

SELECT region, 
       COUNT(s_code) + COUNT(b_code) + COUNT(d_code) AS total
FROM shilpy
GROUP BY region 
ORDER BY region

您可以使用子查询来计算特定的计数，然后获得计数的总数，而无需再次重新扫描整个表：

select *, (count_s + count_b + count_d) as total
from (
  select region, count(s_code) as count_s, count(b_code) as count_b, count(d_code) as count_d
  from shilpy
  group by region 
  order by region
) as s;

Demo here