Antwoorden

select Artist.Name, Album.Title 
from Artist, Album 
Where Artist.ArtistID = Album.ArtistID

select Artist.Name, count(Album.Title)
from Artist, Album 
Where Artist.ArtistID = Album.ArtistID
group by Artist.ArtistId;

select Artist.Name, Track.name
from Artist, Album, Track
Where Artist.ArtistID = Album.ArtistID AND
Track.AlbumID = Album.AlbumID;

select Artist.Name, count(Track.trackid)
from Artist, Album, Track
Where Artist.ArtistId = Album.ArtistID AND
Track.AlbumID = Album.AlbumID
group by Artist.ArtistId;

select Artist.Name, count(Track.trackid)
from Artist, Album, Track
Where Artist.ArtistId = Album.ArtistID AND
Track.AlbumID = Album.AlbumID
group by Artist.ArtistId
order by count(Track.Trackid) desc
Limit 3;

Select Track.Name, Genre.Name
From Track, Genre
Where Track.GenreID = Genre.GenreID and
Genre.name = 'Opera';

select Genre.Name, count(track.trackid), avg(track.Milliseconds)
from Genre, Track
where Track.Genreid = Genre.genreid
group by Genre.Genreid;