Соединения таблиц. JOIN.

select * from film;

select * from "language" l;

select 

f.title,

l."name" as language_name

from 

film f

inner join "language" l

on f.language_id = l.language_id

where 

f.title like 'C%';

select distinct

a.first_name || ' ' || a.last_name as actor_name

from 

film_actor fa

inner join actor a 

on fa.actor_id = a.actor_id 

inner join film f 

on fa.film_id = f.film_id

inner join inventory i 

on i.film_id = f.film_id ;

select * from actor;

select * from inventory i;

select distinct

a.first_name || ' ' || a.last_name as actor_name

from 

film_actor fa

inner join actor a 

using (actor_id) 

inner join film f 

using (film_id)

inner join inventory i 

using (film_id);

select 

f.title 

from 

film f 

left join inventory i 

using (film_id)

where 

i.inventory_id is null;

select 

f.title 

from 

inventory i

right join film f 

using (film_id)

where 

i.inventory_id is null;

select 

f.title 

from 

inventory i

full join film f 

using (film_id)

where 

i.inventory_id is null;

select 

f.title,

a.first_name || ' ' || a.last_name as actor_name

from 

film f 

cross join actor a;

select 

f.title,

a.first_name || ' ' || a.last_name as actor_name

from 

film f 

inner join actor a

on true;

select 

f.title,

a.first_name || ' ' || a.last_name as actor_name

from 

film f, actor a;

select 

f.title,

a.first_name || ' ' || a.last_name as actor_name,

fa.actor_id is not null 

from 

film f 

cross join actor a

left join film_actor fa 

on fa.film_id = f.film_id 

and fa.actor_id = a.actor_id ;