Correct SQL queries and their statements if necessary, and explain corrections

profilert211r
queries.docx

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';