SELECT u.Id, u.DisplayName, COUNT(u.Id) FROM Posts AS p J...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Mathematics

Q&A for people studying math at any level and professionals in related fields

SELECT
  u.Id,
  u.DisplayName,
  COUNT(u.Id)
FROM
  Posts AS p
  JOIN Users AS U
  ON p.OwnerUserId = u.Id
WHERE
  p.PostTypeId = 2 AND
  p.Body LIKE 'http:%' AND
  u.Reputation = 1
GROUP BY
  u.Id,
  u.DisplayName
HAVING
  COUNT(u.Id) > 2
ORDER BY
  u.DisplayName ASC

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results