SELECT 
 CASE WHEN [Subgroup ID] = 1  THEN CAST((SUM (b) / SUM (a) * 100) AS DECIMAL (36,2)) END AS Overall_Math,
 CASE WHEN [Subgroup ID] = 74  THEN CAST((SUM (b) / SUM (a) * 100) AS DECIMAL (36,2)) END AS AA_Math ,
 CASE WHEN [Subgroup ID] = 80  THEN CAST((SUM (b) / SUM (a) * 100) AS DECIMAL (36,2)) END AS White_Math ,
 CASE WHEN [Subgroup ID] = 76  THEN CAST((SUM (b) / SUM (a) * 100) AS DECIMAL (36,2)) END AS Asian_Math ,
 CASE WHEN [Subgroup ID] = 78  THEN CAST((SUM (b) / SUM (a) * 100) AS DECIMAL (36,2)) END AS Hispanic_Math
 
FROM

(
SELECT  [Subgroup ID],
	    SUM(CAST([Students with Scores] AS float)) AS a, 
        CAST([Students with Scores] AS float) *
        CAST(CONVERT(float , (1.0 * CAST([Percentage AT OR Above Proficient] AS float) / 100)) AS VARCHAR) AS b

FROM    CST_ALL
WHERE   ( [District Code] = 64774 )
        AND ( [Test Type] = 'C' )
        AND ( [Test Id] IN ( 7 ) )
        AND ([School Code] = 0000000)
        AND Grade IN ( 2, 3, 4, 5, 6, 7, 8, 9, 10, 11)
        
        GROUP BY [Subgroup ID] , [Students with Scores] ,
       [Percentage At Or Above Proficient] 
)     
        
   AS c    
 
GROUP BY [Subgroup ID]

SELECT 
MAX(Overall) AS Overall,
MAX(AA) AS AA,
MAX(White) AS Whites,
MAX(Asian) AS Asians,
MAX(Hispanic) AS Hispanics

FROM
(
SELECT 
 CASE WHEN [Subgroup ID] = 1  THEN CAST((SUM (b) / SUM (a) * 100) AS DECIMAL (36,2)) END AS Overall,
 CASE WHEN [Subgroup ID] = 74  THEN CAST((SUM (b) / SUM (a) * 100) AS DECIMAL (36,2)) END AS AA ,
 CASE WHEN [Subgroup ID] = 80  THEN CAST((SUM (b) / SUM (a) * 100) AS DECIMAL (36,2)) END AS White ,
 CASE WHEN [Subgroup ID] = 76  THEN CAST((SUM (b) / SUM (a) * 100) AS DECIMAL (36,2)) END AS Asian,
 CASE WHEN [Subgroup ID] = 78  THEN CAST((SUM (b) / SUM (a) * 100) AS DECIMAL (36,2)) END AS Hispanic
 
FROM

(
SELECT  [Subgroup ID],
	    SUM(CAST([Students with Scores] AS float)) AS a, 
        CAST([Students with Scores] AS float) *
        CAST(CONVERT(float , (1.0 * CAST([Percentage AT OR Above Proficient] AS float) / 100)) AS VARCHAR) AS b

FROM    CST_ALL
WHERE   ( [District Code] = 64774 )
       --( [District Code] LIKE CAST(@CDS AS VARCHAR(7)) + '%' )
        AND ( [Test Type] = 'C' )
        AND ( [Test Id] IN ( 7 ) )
        AND ([School Code] = 0000000)
        AND Grade IN ( 2, 3, 4, 5, 6, 7, 8, 9, 10, 11)
        
        GROUP BY [Subgroup ID] , [Students with Scores] ,
       [Percentage At Or Above Proficient] 
)     
        
   AS c    
 
GROUP BY [Subgroup ID]
) 
AS d