homework practice query

0

Please login or register to vote for this query.

(click on this box to dismiss)

スタック・オーバーフローMeta

プログラマーと熱狂的なプログラマーのためのサイトに関する質問と回答

WITH Has100Answers AS
  (SELECT TOP 10 OwnerUserId, COUNT(Id) AS NumPosts FROM Posts 
  WHERE PostTypeId = 2 AND OwnerUserId IS NOT NULL
  GROUP BY OwnerUserId
  HAVING COUNT(Id) >= 100)

SELECT TOP 10 Id AS [User Link], CreationDate, DisplayName FROM Users
WHERE Id IN (SELECT TOP 10 OwnerUserId FROM Has100Answers)
ORDER BY CreationDate DESC

Enter Parameters

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