title: Write a query to find the full name of the actor who has acted in the maximum number of movies
body: <p>My code is as seen below, but I'm not getting the desired answer, which is to get the full name of the actor whose done the maximum number of movies.</p>
  <pre><code>SELECT CONCAT(&quot; &quot;,actor.first_name,actor.last_name) AS Full_name 
  FROM actor INNER JOIN film_actor ON actor.actor_id = film_actor.actor_id
  GROUP BY actor.actor_id
  ORDER BY count(film_actor.actor_id) DESC
  LIMIT 2, 1;
  </code></pre>
  <p><a href="https://i.stack.imgur.com/kVTWy.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/kVTWy.png" alt="enter image description here" /></a></p>