View film_list

This view contains a formatted view of the film table, with a comma-separated list of actors for each film. The view incorporates data from the film, category, film_category, actor, and film_actor tables.

Schema

This view belongs to schema sakila.

Query

SQL

 SELECT film.film_id AS fid,
    film.title,
    film.description,
    category.name AS category,
    film.rental_rate AS price,
    film.length,
    film.rating,
    string_agg(concat((actor.first_name)::text, ' '::text, (actor.last_name)::text), ', '::text) AS actors
   FROM ((((sakila.film
     LEFT JOIN sakila.film_category ON ((film_category.film_id = film.film_id)))
     LEFT JOIN sakila.category ON ((category.category_id = film_category.category_id)))
     LEFT JOIN sakila.film_actor ON ((film.film_id = film_actor.film_id)))
     LEFT JOIN sakila.actor ON ((film_actor.actor_id = actor.actor_id)))
  GROUP BY film.film_id, category.name;

Columns

This view contains 8 columns.

fid: smallint
title: character varying(128)
description: text
category: character varying(25)
price: numeric(4,2)
length: smallint
rating: sakila.rating
actors: text