title: Using Stack Exchange Data Explorer (SEDE) to find users by post count and reputation
body: <p>I want to find out which users have the most reputation with the least amount of posts (less than 10). But why can't I have a <code>where</code> clause before this join? :</p>
  
  <pre><code>SELECT TOP 100 Users.Id, Users.DisplayName AS [Username], Users.Reputation, COUNT(Posts.Id) AS [Post Count] FROM Users
  //WHERE COUNT(Posts.Id) &lt; 10
  JOIN Posts ON Posts.OwnerUserId = Users.Id 
  GROUP BY Users.Id, Users.DisplayName, Users.Reputation
  ORDER BY Users.Reputation DESC;
  </code></pre>
  
  <p>The original user post count example query is at <a href="https://data.stackexchange.com/stackoverflow/query/503051/user-post-count-example" rel="nofollow noreferrer">data.stackexchange.com/stackoverflow/query/503051</a></p>