diff options
| author | mo khan <mo@mokhan.ca> | 2015-11-27 09:30:43 -0700 |
|---|---|---|
| committer | mo khan <mo@mokhan.ca> | 2015-11-27 09:30:43 -0700 |
| commit | 4797ed2eefd3c2b0563f4aa9d78ff57380cccdef (patch) | |
| tree | 06566972f4687da3ee93e301d212a6334dab3b13 | |
| parent | cc6aa03617b264eec7f9c27be29d50cddfaf7764 (diff) | |
find all studios that did not publish a movie in 2006.
| -rw-r--r-- | lib/movies.sql | 1 |
1 files changed, 1 insertions, 0 deletions
diff --git a/lib/movies.sql b/lib/movies.sql index 49cd09d..15cbd0c 100644 --- a/lib/movies.sql +++ b/lib/movies.sql @@ -20,6 +20,7 @@ CREATE TABLE studios ( -- find all pixar movies -- find all studios that don't have a movie. +-- find all studios that did not publish a movie in 2006 -- find all movies published by pixar or disney -- find all movies not published by pixar -- find all movies released after 2004 |