eb (sqllang!g_featureSwitchesLangSvc+28h) 1

CREATE OR ALTER FUNCTION dbo.CountHistoryRowsForProduct
    (@ProductID integer)
RETURNS bigint
WITH SCHEMABINDING
AS
BEGIN
    RETURN
    (
        SELECT COUNT_BIG(*)
        FROM Production.TransactionHistory AS TH
        WHERE TH.ProductID = @ProductID
    );
END;

SELECT COUNT(*)
FROM dbo.Badges AS b
JOIN dbo.Comments AS c
ON b.UserId = c.UserId
OPTION(MERGE JOIN, RECOMPILE);

WITH Comments AS
(
SELECT DISTINCT c.UserId
FROM dbo.Comments AS c
)
SELECT COUNT(*)
FROM dbo.Badges AS b
JOIN Comments AS c
ON b.UserId = c.UserId
OPTION(MERGE JOIN, RECOMPILE)

WITH Comments AS
(
SELECT c.UserId, COUNT(*) AS c_uid
FROM dbo.Comments AS c
GROUP BY c.UserId
)
SELECT SUM(c.c_uid)
FROM dbo.Badges AS b
JOIN Comments AS c
ON b.UserId = c.UserId
OPTION(MERGE JOIN, RECOMPILE)