https://antonz.org/fancy-ql/

movies.sql

select
    title,
    name,
    avg(score)
from movies m
    join movies_actors using(movie_id)
    join actors a using(actor_id)
    join (
        select movie_id
        from actors join movies_actors using(actor_id)
        where actors.name = 'Zendaya'
    ) sub using(movie_id)
    left outer join reviews using(movie_id)
group by 
    title,
    name