select a.job, a.first_year_mon, a.first_year_cnt, b.second_year_mon, b.second_year_cnt from ( select job, date_format(date, "%Y-%m") as first_year_mon, sum(num) as first_year_cnt from resume_info where year(date)...