title: Write a query to find the full name of the actor who has acted in the third most number of movies in mysql?
body: <p>I have used the code below for finding the actor with max movies but I would need the third actor now:    </p>
  
  <pre><code>SELECT CONCAT_WS(" ",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 1;
  </code></pre>