filmLibrary

/*Please add ; after each select statement*/
CREATE PROCEDURE filmLibrary()
BEGIN

    SELECT aa.actor, aa.age from movies m
    JOIN starring_actors sa on sa.movie_name = m.movie
    JOIN actor_ages aa on sa.actor = aa.actor
    WHERE m.genre = (SELECT genre FROM movies GROUP BY genre ORDER BY COUNT(*) DESC LIMIT 1)
    order by aa.age  desc, aa.actor
;
END