Yurttas/PL/DBL/oracle/F/01/Movie/q02.sql

From ZCubes Wiki
Revision as of 23:01, 4 November 2013 by MassBot1 (talk | contribs) (Created page with "<syntaxhighlight lang="sql" line start="1" enclose="div"> REM REM q02.sql REM REM Find all movies of 1998 ordered by title REM and studios in ascending order grouped REM by B...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search 
 1REM
 2REM q02.sql
 3REM
 4REM Find all movies of 1998 ordered by title
 5REM and studios in ascending order grouped 
 6REM by BW and color.
 7REM
 8
 9SELECT title, studioname
10FROM Movie
11WHERE year = 1998
12GROUP BY filmtype, title, studioname
13ORDER BY title ASC, studioname ASC;
Retrieved from "http://wiki.zcubes.com/index.php?title=Yurttas/PL/DBL/oracle/F/01/Movie/q02.sql&oldid=79358"