select
actor_id,
concat(first_name, ' ', last_name) actor_name,
f.title film_title,
c.name category
from sakila.actor a
join sakila.film_actor fa using(actor_id)
join sakila.film_text f using (film_id)
join sakila.film_category fc using (film_id)
join sakila.category c using (category_id);