select t1.job ,date_format(t1.date,'%Y-%m') as first_year_mon ,sum(t1.cnt) as first_year_cnt ,date_format(t2.date,'%Y-%m') as second_year_mon ,sum(t2.cnt) as second_year_cnt from (select job ,date ,sum(num) as cnt from resume_info group by job,date_format(date,'%Y-%m')) t1 #first_y...
