(SELECT Count(id)                      AS per_count,
               personnel_provide_id,
               Datepart(month, returned_date) AS datepart_month
        FROM   yh_personnel
        WHERE  yh_personnel.personnel_type&60 = 32
               AND returned_date BETWEEN ‘2020-1-1‘AND ‘2020-12-31‘
        GROUP  BY personnel_provide_id,
                  Datepart(month, returned_date)) AS tb_base

SELECT (SELECT option_name
        FROM   yh_select_option
        WHERE  option_id = P_yq
               AND option_tags = ‘PTYQ‘) AS subject,
       Count(CASE
               WHEN department = 11 THEN 1
             END)                        AS channel_expansion_count,
       Count(CASE
               WHEN department = 14 THEN 1
             END)                        AS channel_maintenance_count,
       Count(CASE
               WHEN department = 12 THEN 1
             END)                        AS business_count,
       Count(CASE
               WHEN department = 13 THEN 1
             END)                        AS project_count,
       Count(CASE
               WHEN department = 15 THEN 1
             END)                        AS business_support_count,
       Count(CASE
               WHEN department = 16 THEN 1
             END)                        AS assets_manager_count,
       Count(CASE
               WHEN department = 17 THEN 1
             END)                        AS clearing_count,
            count(case when P_jd=4 then 1 end ) as invalid_count,
            ‘/‘ as timeout_count
FROM   yh_ps_demand_application
       LEFT JOIN yh_manager
              ON yh_manager.id = yh_ps_demand_application.P_fqr
group by P_yq