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