title: select max() from count()
body: <blockquote>
    <p><strong>Possible Duplicate:</strong><br>
    <a href="https://stackoverflow.com/questions/1888779/every-derived-table-must-have-its-own-alias">every derived table must have its own alias</a>  </p>
  </blockquote>
  
  
  
  <p>I need to find maximum of actions per user</p>
  
  <p>table columns: <code>action_id</code>, <code>action_status</code>, <code>user</code></p>
  
  <p>request: <br></p>
  
  <pre><code>SELECT MAX(`counted`) FROM
  (
  SELECT COUNT(*) AS `counted`
  FROM `table_actions`
  WHERE `status` = "good"
  GROUP BY `user`
  )
  </code></pre>
  
  <p>error message: "Every derived table must have its own alias"</p>
  
  <p>what is wrong?..</p>