0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professionals and students of engineering

SELECT
    ROW_NUMBER() OVER(ORDER BY Reputation DESC) AS [#], 
    Users.Id AS [User Link], 
    Reputation
FROM
    Tags
     JOIN PostTags ON PostTags.TagId = Tags.id
     JOIN Posts ON Posts.ParentId = PostTags.PostId
     JOIN Users ON Posts.OwnerUserId = Users.Id          
WHERE
    LOWER(Location) LIKE LOWER('%IRAQ%') AND
    LOWER(Tags.TagName) LIKE LOWER('%java%')

GROUP BY  Users.Id,Reputation
ORDER BY
    Reputation DESC;

fork query

edited jul 2 20

created jul 2 20 anonymous