Help writing query for MS SQL Server
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.