group by

1.想统计简历回流状态是3和5的申请各多少个

elect ats_status,count(ats_status) from jobdb.job_application where position_id=2421796 group by ats_status

 

2.多表连接，查询猎聘每日简历回流情况