instruction: Most viseted post for each user.
response: SELECT Users.DisplayName, Posts.Title, Posts.ViewCount FROM Users INNER JOIN Posts ON Posts.OwnerUserId = Users.Id WHERE Posts.ViewCount = (SELECT MAX(p.ViewCount) FROM Posts AS p WHERE p.OwnerUserId = Users.Id GROUP BY p.OwnerUserId) ORDER BY ViewCount