title: Not displaying average values for users with more than one instance
body: <p>Basically, I am fairly new to SQL and I am playing around with it. It is fun and interesting and basically I am trying to select the userId and average gametime for each user who has more than one game session. This is my table below:</p>
  
  <pre><code>id  | userId |gameTime  |
  ________________________    
  1   |    1   |     10   | 
  2   |    2   |     10   |
  3   |    3   |     15   |
  4   |    1   |     10   |
  5   |    2   |     25   |
  _________________________
  
  
   CREATE TABLE game_session(
    id INTEGER PRIMARY KEY,
    userId INTEGER NOT NULL,
    gameTime DECIMAL NOT NULL);
  
  INSERT INTO game_session VALUES
    (1, 1, 10),
    (2, 2, 10),
    (3, 3, 15),
    (4, 1, 10),
    (5, 2, 25);
  </code></pre>
  
  <p>So I just want to display all instances of userID more than once and its total average time. I don't want to display the count row in the end.</p>
  
  <p>I wrote my script but it isn't displaying the table <strong>WITHOUT THE COUNT(userID)</strong> AND it is showing the userID even for once instance, not more than 1!</p>
  
  <p>This is my script: </p>
  
  <pre><code>SELECT userID, AVG(gameTime)
  FROM game_session
  WHERE ((SELECT COUNT(userID) FROM game_session) &gt; 1)
  GROUP BY userID
  </code></pre>
  
  <p>Where am I going wrong?</p>