0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for software engineers working on automated testing, continuous delivery, service integration and monitoring, and building SDLC infrastructure

-- 4. Find all users from Latvia who have Editor badge.
-- In the second column, please, add the
-- last question post created by that user.
SELECT TOP 10 Users.Id, Users.DisplayName, LastQuestionPost.*
FROM Users
INNER JOIN Badges ON Badges.UserId = Users.Id AND Badges.Name = 'Editor'
CROSS APPLY (
    SELECT TOP 1 *
    FROM Posts
    WHERE Posts.OwnerUserId = Users.Id
    ORDER BY Posts.CreationDate DESC
) LastQuestionPost;

fork query

edited nov 17 jon.doe46305

created nov 17 anonymous