用户N1887570(提问者) 能帮我看下上面sql怎么改吗

回复

2022-01-06 10:37 

取消 回复

luojian0323 回复 用户N1887570(提问者) group by replace(area_company,\'市\',\'\'),其他字段

回复

2022-01-06 10:45 

取消 回复

用户N1887570(提问者) select roast_season,area_company,smoke_level,avg(avg_slice_water) as 含水率,avg(standard_stem_rate) as 含梗率,avg(standard_slice_rate) as 出片率,sum(check_amount) as 检测次数 from physics_check where is_deleted=\'0\' and work_month in (\'十月\') and smoke_level=\'C3F\' group by area_company,smoke_level,roast_season

回复

2022-01-06 10:35 

取消 回复

用户N1887570(提问者) area_company 就是那个需要模糊查询的

回复

2022-01-06 10:36 

取消 回复