Question
Which people are noted as being principal actors in a movie, but aren't noted as playing a character in that movie? The movie ist of
Which people are noted as being principal actors in a movie, but aren't noted as playing a character in that movie? The movie
ist of relations Schema | Name | Type | Owner --------+--------------+-------+---------- public | aliases | table | postgres public | known_for | table | postgres public | movie_genres | table | postgres public | movies | table | postgres public | people | table | postgres
Table "public.people" Column | Type | Collation | Nullable | Default -----------+----------+-----------+----------+--------- id | integer | | not null | name | text | | not null | year_born | yeartype | | | year_died | yeartype | | | public | plays | table | postgres public | principals | table | postgres (7 rows)
Table "public.movies" Column | Type | Collation | Nullable | Default -----------+------------------+-----------+----------+--------- id | integer | | not null | title | text | | not null | year_made | yeartype | | not null | runtime | minutes | | | rating | double precision | | | nvotes | counter | | |
Table "public.principals" Column | Type | Collation | Nullable | Default -----------+---------+-----------+----------+--------- movie_id | integer | | not null | ordering | counter | | not null | person_id | integer | | not null | role | text | | not null |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started