T sql使用内连接选择pivot

I have query as below

我有如下查询

    SELECT  cpn.ProjectName ,
            COUNT(c.case_ID) AS 'Total' ,
            DATENAME(month, DATEADD(month, MONTH(ca.xdate), 0) - 1) AS Month
    FROM    cases c
            JOIN case_action ca ON c.case_ID = ca.case_ID
            INNER JOIN tblCaseProjectsNew cpn ON cpn.ID = c.Project_ID
            INNER JOIN reseller_user_profiles rup 
                ON rup.reseller_user_ID = c.reseller_user_ID
    WHERE   cpn.ID = 1
            AND ca.status_ID = 0
    GROUP BY 
         cpn.ProjectName ,
         DATENAME(month, DATEADD(month, MONTH(ca.xdate), 0) - 1) 
    SELECT  cp