0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for scientific skepticism

SELECT 
  Users.Id, 
  Users.DisplayName,
  Users.Reputation, 
  Users.Location, 
  Tags.tagname
FROM 
  Users
INNER JOIN Posts ON Posts.OwnerUserId = Users.Id
INNER JOIN PostTags ON PostTags.TagId = Posts.ParentId
INNER JOIN Tags ON PostTags.TagId = Tags.id

where Tags.tagname = 'c#' and 

(    LOWER(Users.Location) LIKE '%croatia%'
    OR UPPER(Users.Location) LIKE '%CROATIA%'
    or Users.Location like '%Croatia%'
)
AND Users.Reputation >= 2000

fork query

edited sep 19 18 antonio.bakula

created sep 16 13 anonymous