Plan aeaa722a-6ab7-48e9-832f-b027906816e1

 1SELECT
 2  *,
 3  (
 4    SELECT
 5      name
 6    FROM
 7      category
 8      join film_category using(category_id)
 9    where
10      film_id = film.film_id
11  )
12FROM
13  film