select a.job,a.date1 as first_year_mon,a.cnt as first_year_cnt,b.date1 as second_year_mon,b.cnt as second_year_cntfrom (select job,left(date,7) as date1,sum(num) as cntfrom resume_info group by date1,job)ajoin(select job,left(date,7) as date1,sum(num) as cntfrom resume_info group by date1,job)bon ri...