0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for SharePoint enthusiasts

SELECT ParentId AS QuestionId
FROM Posts
WHERE PostTypeId = 2
GROUP BY ParentId
HAVING COUNT(*) > 5;

SELECT ParentId AS QuestionId, AVG(Score) AS AverageScore
FROM Posts
WHERE PostTypeId = 2
GROUP BY ParentId
HAVING COUNT(*) > 5;

SELECT U.Id AS UserId, U.Reputation
FROM Users U
WHERE NOT EXISTS (
    SELECT 1
    FROM Posts P2
    WHERE P2.OwnerUserId = U.Id AND P2.PostTypeId = 1 
)
AND (
    SELECT COUNT(*) 
    FROM Posts P 
    WHERE P.OwnerUserId = U.Id AND P.PostTypeId = 2 
) > 10
ORDER BY U.Reputation DESC;

SELECT P.OwnerUserId AS UserId, AVG(P.Score) AS QualityScore
FROM Posts P
WHERE P.PostTypeId = 2 
GROUP BY P.OwnerUserId
HAVING COUNT(*) > 0
ORDER BY QualityScore DESC;


SELECT P.OwnerUserId AS UserId, COUNT(*) AS PostCount
FROM Posts P
GROUP BY P.OwnerUserId;


SELECT C.UserId, COUNT(*) AS CommentCount
FROM Comments C
GROUP BY C.UserId;

SELECT P.OwnerUserId AS UserId, COUNT(*) AS AnswerCount
FROM Posts P
WHERE P.PostTypeId = 2 -- فقط پاسخ‌ها
GROUP BY P.OwnerUserId
HAVING COUNT(*) > 1000;

fork query

edited dec 11

created dec 11 anonymous