Retrieve all information about artist:
SELECT *
FROM ARTIST;
Retrieve specific track from the album:
SELECT TRACK=’name’
FROM ALBUM
WHERE TRACK.NAME=’Track1’
Update operation with an artist table:
UPDATE ARTIST
SET ContactName=’name’, Location=’city’
WHERE ArtistName=’name’, Location=’usa’;
Find the sum of the times on each album:
SELECT SUM
FROM TRACKS
GROUP BY ALBUMTITLE
ORDER BY duration DESC;
To retrieve all tracks with duration more than five minutes and uncompressed sound:
SELECT *
FROM TRACKS
WHERE DURATION > 300 AND QUALITY=’LOSSLESS’;