#9

0

Please login or register to vote for this query.

(click on this box to dismiss)

Photography

Q&A for professional photographers, photo editors, and serious enthusiasts

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

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results