title: Select the actor with the most movies played
body: <p>I have 2 tables.
  1) dbo.movies</p>
  
  <pre><code>+------------+-------------+------------+
  | movie_id   | movie_name  | actor_id   | 
  +------------+-------------+------------+
  | 1          | name1       |     1      | 
  | 2          | name2       |     1      | 
  | 3          | name3       |     4      | 
  | 4          | name4       |     2      |
  | 5          | name5       |     1      |
  | 6          | name6       |     5      |
  | 7          | name7       |     3      |
  +------------+-------------+------------+
  </code></pre>
  
  <p>2) dbo.actors</p>
  
  <pre><code>+------------+-------------+
  | actor_id   | actor_name  | 
  +------------+-------------+
  | 1          | name1       | 
  | 2          | name2       |
  | 3          | name3       |
  | 4          | name4       |
  | 5          | name5       |
  +------------+-------------+
  </code></pre>
  
  <p>I want to <code>SELECT</code> the <code>actor_id</code> and <code>actor_name</code> that played in the most movies.</p>
  
  <p>Although I know how to find the most movies an actor has played, I can't find who that actor is:</p>
  
  <pre><code>select max(y.x)
  from (select count(actor_id) as x from movies group by actor_id) y
  </code></pre>