sql的一些特殊用法

DECLARE @parent_folder_id UNIQUEIDENTIFIER;
SET @parent_folder_id = '12';

SELECT k.folder_name,
SUM(k.total) AS total,
SUM(k.Deliverable)AS deliverable,
SUM(k.Deliverable)/SUM(k.total) AS DeliveryRate,
SUM(k.ThisWeek_total) AS thisWeek_total,
SUM(k.LastWeek_total)AS lastweek_total
 FROM (SELECT b.folder_name ,
        b.folder_id,
        1 total ,
        CASE WHEN ( a.deliverable=1 )  THEN 1 ELSE 0  END Deliverable,
        CASE WHEN ( DATENAME(week, a.create_date) = DATENAME(week, GETDATE()) AND DATENAME(year, a.create_date) = DATENAME(year, GETDATE())) THEN 1 ELSE 0 END ThisWeek_total ,
        CASE WHEN ( DATENAME(week, a.create_date) + 1 = DATENAME(week,GETDATE()) AND DATENAME(year, a.create_date) = DATENAME(year, GETDATE()))  THEN 1 ELSE 0 END  LastWeek_total
        
FROM    project a
        LEFT JOIN system_folder b ON a.folder_id = b.folder_id
WHERE   a.delete_user IS NULL
        AND b.parent_folder_id = @parent_folder_id)k
GROUP BY k.folder_id,k.folder_name