修改第二个查询
SELECt Tree.Type as 'Requirement Type', COUNT(CASE WHEN [Tree].[creationDate] >= ('2010-01-01') and [Tree].[creationDate] < ('2020-01-01') THEN Tree.Type END) AS 'Number in Creation Range'FROM [Tree] INNER JOIN @ReqType As RT on RT.Type = Tree.TypeINNER JOIN [Project_INFO] ON [Project_INFO].[ProjectID]=[Tree].[Project_ID] INNER JOIN @CreationCount AS CCount ON CCount.baselineID=Tree.baseline_ID WHERe [Project_INFO].[Name] = 'Address Book' AND CCount.Name = 'Current baseline' GROUP BY tree.Type
