James Dean was one of America’s iconic actors of the mid 20th-century; a remarkable feat, considering that he only made three movies. We chose him as an example partly because of his iconic status, but mostly because the fact that he made only three movies makes it easier to do simple cardinality computations on the set of movies that he made.

You can download the dataset for these queries here.

You can cross-reference the queries to the book by query number or name.

Query ch6.1 James Dean Played In visit query on data.world

A simple query that shows the movies James Dean played in.

Query ch6.2 Who directed James Dean? visit query on data.world

Expanding on that query, who directed those movies?

Query ch6.3 Who directed James Dean movies? visit query on data.world

Combining these two queries, we show both the movie and the director.