Q&A for professional and enthusiast programmers
SELECT u.DisplayName, p.id [Post Link], p.CreationDate, score, CASE WHEN communityowneddate IS NOT NULL THEN '*' ELSE NULL END iscommunity , p.ViewCount FROM posts p INNER JOIN users u ON p.owneruserid = u.id WHERE p.posttypeid = 1 AND p.closeddate IS NOT NULL AND u.reputation > 20000 ORDER BY u.DisplayName, p.Title