0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for people living abroad on a long-term basis

-- SELECT Id, DisplayName FROM Users 
-- WHERE (SELECT COUNT(*) FROM Posts WHERE PostTypeId = 1 AND OwnerUserId = Users.Id AND (Tags LIKE '%sql%')) >= 3 AND
-- WHERE (SELECT COUNT(*) FROM Posts WHERE PostTypeId = 2 AND OwnerUserId = Users.Id AND (Posts.ParentId IN (SELECT ParentId FROM Posts WHERE PostTypeId = 2 AND Tags LIKE '%java%'))) >= 3
SELECT TOP 100 Tags FROM Posts WHERE PostTypeId = 1 AND Tags LIKE '%java%'

fork query

edited dec 13 17

created dec 13 17 anonymous