View staff_list

This view provides a list of all staff members, including address and store information. The view incorporates data from the staff and address tables.

Schema

This view belongs to schema sakila.

Query

SQL

 SELECT s.staff_id AS id,
    concat((s.first_name)::text, ' '::text, (s.last_name)::text) AS name,
    a.address,
    a.postal_code AS "zip code",
    a.phone,
    city.city,
    country.country,
    s.store_id AS sid
   FROM (((sakila.staff s
     JOIN sakila.address a ON ((s.address_id = a.address_id)))
     JOIN sakila.city ON ((a.city_id = city.city_id)))
     JOIN sakila.country ON ((city.country_id = country.country_id)));

Columns

This view contains 8 columns.

id: smallint
name: text
address: character varying(50)
zip code: character varying(10)
phone: character varying(20)
city: character varying(50)
country: character varying(50)
sid: smallint