Разбор домашнего задания 5.2

select 

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

count(*) as film_cnt

from 

actor a 

left join film_actor fa 

on a.actor_id = fa.actor_id 

group by 

actor_name,

a.actor_id 

order by 

film_cnt desc, 

actor_name

limit 5

offset 5;