Relational Divison

relational_division_example.sql

-- Fetch all films two actors appeared in together and order alphabetically
-- film, film_actor and actor tables, with a simple schema

select f.title
from film f
inner join (
  select fa.film_id
  from film_actor fa
  where fa.actor_id in (105, 122)
  group by fa.film_id
  having count(*) = (
    select count(*)
    from actor
    where actor.actor_id in (105, 122)
  )) f2 on f.film_id = f2.film_id 
order by f.title