监测 工厂类型分布数量 select b.name,count(*) from cus_enterprise a LEFT JOIN sys_industry b on a.industry_id=b.id GROUP BY b.name 监测 类型 废水、废气 select b.name,count(*) from cus_point a LEFT JOIN sys_dict b on a.type=b.value GROUP BY b.value