|
ReleaseTable |
||
|
ReleaseID |
int |
NotNull |
|
RelteaseTitle |
String |
|
|
ReleaseGroup |
String |
|
|
ReleaseDate |
DateTime |
NotNull |
|
MusicTable |
||
|
MusicID |
int |
NotNull |
|
MusicTitle |
String |
|
|
MusicLength |
DateTime |
|
ContentsTable |
||
|
ReleaseID |
int |
NotNull |
|
MusicID |
int |
NotNull |
|
Sequence |
int |
SELECT r.ReleaseID, r.ReleaseTitle, m.MusicTitle
FROM ReleaseTable r, MusicTable m, ContentsTable c
WHERE r.ReleaseID = c.ReleaseID AND c.MusicID = m.MusicID AND m.MusicLength >
(SELECT MusicLength
FROM MusicTable
WHERE MusicTitle = “Master of Puppets”);
What Does it Return?
https://www.youtube.com/watch?v=Z5Sr__xoD8c