############# 1.2 ##################
#5
#SELECT IDARTIST,RANK FROM album WHERE RANK > 30000 ORDER BY RANK DESC;
#6
#SELECT DISTINCT(ASIN) FROM track WHERE DISK > 2;
#7
#SELECT TITLE,PRICE FROM album WHERE TITLE LIKE "za%" AND PRICE < 20;
#8
#SELECT IDARTIST, `RELEASE` FROM ALBUM WHERE RANK BETWEEN 800 AND 1000 ORDER BY `RELEASE`;

############# 1.3 ##################

/*
#1
SELECT SONG FROM track WHERE ASIN = (SELECT ASIN FROM ALBUM WHERE TITLE ='zas');
#ou
SELECT SONG FROM track T, ALBUM A WHERE TITLE ='zas' AND A.ASIN = T.ASIN;
*/

/*
#2
SELECT DISTINCT(A.TITLE)
FROM track T, album A
WHERE T.ASIN = A.ASIN
AND T.DISK > 2;
*/