WITH FirstPostIds AS ( SELECT OwnerUserId, MIN(Id) FirstP...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

WITH FirstPostIds AS (
  SELECT OwnerUserId, MIN(Id) FirstPostId FROM Posts
  GROUP BY OwnerUserId
)
SELECT AVG(Score) FROM Posts
WHERE Posts.Id IN (SELECT FirstPostId FROM FirstPostIds)

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results