#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
      (SELECT COUNT(*) FROM Posts WHERE PostTypeId = 2 AND OwnerUserId = Users.Id AND (Tags LIKE '%java%')) >= 10

Enter Parameters

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