0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional and enthusiast programmers

-- Query 1: Get active users and their post counts (Questions and Answers)
SELECT 
  p.OwnerUserId AS UserId,
  u.DisplayName,
  SUM(CASE WHEN p.PostTypeId = 1 THEN 1 ELSE 0 END) AS QuestionsCount,
  SUM(CASE WHEN p.PostTypeId = 2 THEN 1 ELSE 0 END) AS AnswersCount,
  COUNT(*) AS TotalPosts
FROM Posts p
INNER JOIN Users u ON p.OwnerUserId = u.Id
WHERE p.CreationDate >= '2020-11-01'
  AND p.CreationDate <= '2024-10-31'
  AND p.OwnerUserId IS NOT NULL
  AND p.PostTypeId IN (1, 2)
GROUP BY p.OwnerUserId, u.DisplayName
HAVING COUNT(*) > 0;

fork query

created nov 4 jon.doe32071