1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22
|
SQL> -- 15. Les albums de chaque artiste ayant le plus grand nombre de piste
SQL> SELECT id_artiste_principal, Albums.id_album, List.id_album2
2 FROM (SELECT COUNT(id_album) As "NOMBRE DE PISTE",id_album
3 FROM Interpretations
4 GROUP BY id_album) List, Albums
5 WHERE Albums.id_album = list.id_album
6 ORDER BY id_artiste_principal,id_album2 DESC
7 /
ID_ARTISTE_PRINCIPAL ID_ALBUM NOMBRE DE PISTE
-------------------- ---------- ----------
1 2 4
1 1 3
2 3 2
3 4 2
5 6 4
5 7 3
6 rows selected.
SQL> |
Partager