select factory_name as 工厂名称,actual_date as 日期 ,class_id as 班次,car_brand as 品牌,duty_part as 责任部门,io_problem_num as 问题项数1,function_problem_num as 问题项数2,rain_problem_num as 问题项数3, io_check_num as 车数1function_check_num as 车数2rain_check_num as 车数3unqualified_rate as 不合格率 from ads_t022_qm_xszc_unqualified_rate_d这个是数据库表里面的,工厂名称只有A B C三个工厂,品牌有D E F个品牌,怎么可以实现在A工厂下计算DEF相加后整体的问题数,相当预览时包含D E F 整体,同时ABC三个工厂也可以AB合并成一个,ABC合并成一个,来计算。图片里面达成结果都是问题数/车数。求各位大神帮忙