Q&A for practitioners of the art and science of signal, image and video processing
SELECT * FROM (SELECT u.Id, u.DisplayName, u.Reputation, COUNT(p.OwnerUserId) AS "Posts", UpVotes, DownVotes, UpVotes + DownVotes AS "Votes" FROM Users u LEFT 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