select roast_season,left(area_company,2)as area_company1, AVG(total_sugar_ave) AS 总糖,AVG(nicotine_ave) as 烟碱,AVG(chlorine_ave) as 氯,AVG(potassium_ave) as 钾,AVG(reducing_sugar_ave) as 还原糖,AVG(total_nitrogen_ave) as 总氮,sum(check_amount) as 检测次数 from chemistry_check where smoke_flag='0' and smoke_level LIKE 'B%' AND work_month in ('${月份}')group by roast_season,area_company1
