SELECT ranks, movie_name, director
  FROM box_office a
 WHERE YEAR(release_date) = 2019
   AND EXISTS (SELECT 1
                FROM box_office b
               WHERE YEAR(release_date) = 2018
                 AND a.movie_name = b.movie_name
                 AND a.director = b.director);