diff options
| author | mo khan <mo@mokhan.ca> | 2015-11-25 09:28:04 -0700 |
|---|---|---|
| committer | mo khan <mo@mokhan.ca> | 2015-11-25 09:28:04 -0700 |
| commit | 131bc2e4135503184115ee2d032337701f0253bb (patch) | |
| tree | bf9a9763194a72e2554cca2f4909f0a6a5117d11 | |
| parent | 6e0d8bc3ab7853a7c1011c82979d2fb6f9f59b93 (diff) | |
change text in sql questions.
| -rw-r--r-- | lib/movies.sql | 20 |
1 files changed, 10 insertions, 10 deletions
diff --git a/lib/movies.sql b/lib/movies.sql index 79c6a80..f045e19 100644 --- a/lib/movies.sql +++ b/lib/movies.sql @@ -18,13 +18,13 @@ CREATE TABLE studios ( -- 5 Disney -- \. --- Can find all pixar movies --- Can find all movies published by pixar or disney --- Can find all movies not published by pixar --- Can find all movies released after 2004 --- Can find all movies released between 1982 and 2003 - Inclusive --- Sorts all movies by descending title --- Sorts all movies by ascending title --- Sorts all movies by descending release date --- Sorts all movies by ascending release date --- Sorts all movies by preferred studios and release date ascending +-- find all pixar movies +-- find all movies published by pixar or disney +-- find all movies not published by pixar +-- find all movies released after 2004 +-- find all movies released between 1982 and 2003 - Inclusive +-- sort all movies by descending title +-- sort all movies by ascending title +-- sort all movies by descending release date +-- sort all movies by ascending release date +-- sort all movies by preferred studios and release date ascending |