0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for pro webmasters

SELECT NumberOfComments = COUNT(1)
FROM dbo.Comments;

SELECT NumberOfCommentsOnMySQLPosts = COUNT(1)
FROM dbo.Comments c
WHERE EXISTS (
    SELECT 1
    FROM dbo.Posts p
    WHERE p.Id = c.PostId
        AND p.Tags LIKE N'%mysql%'
);

SELECT NumberOfCommentsOnSQLServerPosts = COUNT(1)
FROM dbo.Comments c
WHERE EXISTS (
    SELECT 1
    FROM dbo.Posts p
    WHERE p.Id = c.PostId
        AND p.Tags LIKE N'%sql-server%'
);

SELECT UsersWhoLeftOneOrMoreComment = COUNT(1)
FROM dbo.Users u
WHERE EXISTS (
    SELECT 1
    FROM dbo.Comments c
    WHERE c.UserId = u.Id
    );
    
SELECT [Year] = DATEPART(YEAR, c.CreationDate)
    , [Month] = DATEPART(MONTH, c.CreationDate)
    , NumberOfComments = COUNT(1)
FROM dbo.Comments c
GROUP BY DATEPART(YEAR, c.CreationDate)
    , DATEPART(MONTH, c.CreationDate)
ORDER BY DATEPART(YEAR, c.CreationDate)
    , DATEPART(MONTH, c.CreationDate);

fork query

edited aug 9 22 Hannah.Vernon

created feb 5 21 Hannah Vernon