0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for professional mathematicians

SELECT * FROM
  (SELECT u.Id, u.DisplayName, u.Reputation,
    COUNT(p.OwnerUserId) AS "Posts", 
    UpVotes, DownVotes, UpVotes + DownVotes AS "Votes"

  FROM Users u 
  INNER JOIN Posts p ON p.OwnerUserId = u.Id

  WHERE u.Id != -1
     AND UpVotes + DownVotes < 30
     AND UpVotes + DownVotes > 4
     AND u.Reputation > 125
     AND u.Reputation < 300
  GROUP BY u.Id, u.DisplayName, u.Reputation, u.UpVotes, u.DownVotes) inner_query
  
WHERE
  inner_query.Posts < 4
ORDER BY Votes

view current version

edited oct 19 17

created oct 19 17 Emrakul