SELECT
SUM(b.HardBounceCount) AS HardBounceCount,
SUM(b.SoftBounceCount) AS SoftBounceCount,
SUM(b.BlockBounceCount) AS BlockBounceCount,
SUM(b.UnknownBounceCount) AS UnknownBounceCount,
SUM(b.TechnicalBounceCount) AS TechnicalBounceCount,
SUM(b.BounceCount) AS BounceCount,
SUM(b.SendCount) AS SendCount,
b.Domain AS Domain
FROM [SubscriberBounces] b
GROUP BY b.Domain

SELECT
SUM(b.HardBounceCount) AS HardBounceCount,
SUM(b.SoftBounceCount) AS SoftBounceCount,
SUM(b.BlockBounceCount) AS BlockBounceCount,
SUM(b.UnknownBounceCount) AS UnknownBounceCount,
SUM(b.TechnicalBounceCount) AS TechnicalBounceCount,
SUM(b.BounceCount) AS BounceCount,
cast(round((SUM(b.BounceCount)*100.0)/SUM(b.SendCount),2) as numeric(5,2)) as BouncePercent,
SUM(b.SendCount) AS SendCount,
b.Domain AS Domain
FROM [dbo].[subscriberBounces] b
GROUP BY b.Domain