Help writing query for MS SQL Server I need to write a MS SQL Server query statement that will generate the result set table name SUMMARY from the DETAIL table

Server name: Development
Database name: Test  

                  DETAIL            
STATE     Total BadEggs  GoodEggs   Unknown
Kansas      5      2        2         1
Texas       10     5        4         1
Texas       2      0        2         0
Georgia    20      5        5        10
Maine      25     15        5         5
Florida     5      1        2         2
Texas       8      4        2         2
Georgia     9      3        4         2
Maine       5      2        1         2
Florida    11      1        5         5
Texas       2      2        0         0
Florida     5      2        1         2
New York   20      5        5         10
New York    6      2        2         2
Alabama    10      3        4         3
Alabama    30     12       15         3
Alabama     4      1        1         2
Alabama     8      3        2         3
       185  



                  SUMMARY               
STATE     Total  BadEggs   GoodEggs Unknown
Kansas      5        2          2   1
Texas      22       11          8   3
Georgia    29        8          9   12
Maine      30       17          6   7
Florida    21        4          8   9
New York   26        7          7   12
Alabama    52       19          22  11
Total     185       68          62  55
SELECT ISNULL([State],'Total'), SUM(Total), SUM(GoodEggs), SUM(BadEggs)
FROM Detail
GROUP BY
GROUPING SETS (([State]), ());


Although you should probably just do GROUP BY [State] and provide the total row and right column in your application.