Difference between revisions of "Yurttas/PL/DBL/mysql/F/01/00/Movies/q02.sql"
Jump to navigation
Jump to search
(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...") |
(No difference)
|
Latest revision as of 16:23, 3 November 2013
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
11\. set-db.sql
12
13SELECT title, studioname
14FROM Movie
15WHERE year = 1998
16GROUP BY filmtype, title, studioname
17ORDER BY title ASC, studioname ASC;