Yurttas/PL/DBL/postgres/F/01/Movies/q02.sql

 1/*
 2REM
 3REM q02.sql
 4REM
 5REM Find all movies of 1998 ordered by title
 6REM and studios in ascending order grouped 
 7REM by BW and color.
 8REM
 9*/
10
11SELECT current_schema();
12SET search_path to "movies";
13
14SELECT title, studioname
15FROM Movie
16WHERE year = 1998
17GROUP BY filmtype, title, studioname
18ORDER BY title ASC, studioname ASC;