SELECT sum(case WHEN speciality='软件工程' then 1 END) AS cjjyrs, sum(case WHEN employment='已经签约' then 1 End) AS yjqyrs, sum(case WHEN employment='有意向' then 1 end) AS yyxrs, sum(case WHEN employment='有见习意向' then 1 end) AS yjxyxrs, sum(case WHEN employment='自主创业' then 1 end) AS zzcyrs, sum(case WHEN employment='灵活就业' then 1 end) AS lhjyrs, sum(case WHEN employment='升学深造' then 1 end) AS sxszrs, sum(case WHEN employment='申请出国' then 1 end) AS sqcgrs, sum(case WHEN employment='申请暂缓就业' then 1 end) AS sqzhjyrs, sum(case WHEN employdifficulty=1 then 1 end) AS jyknrs, sum(case WHEN homedifficulty=1 then 1 end) AS jtknrs FROM (jc_jobstatistics2 right join jc_stuinfo on jc_jobstatistics2.uid=jc_stuinfo.uid)