Yurttas/PL/DBL/oracle/F/01/Movie/q02.sql
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;