Noms des chansons du groupe Rage Against The Machine
The Battle of Los Angeles Rage Against the Machine Renegades 2007-04-29: Coachella Festival, Indio, CA, USA Evil Empire People of the Sun Clear the Lane Unreleased and Remixed Part 1 Killing in the Name / Bullet in the Head People of the Sun EP
Requete 10
Nom de la première chanson sortie par The Police
Roxanne ’97
Requete 11
Nom de l'artiste qui le plus de follower
Ed Sheeran
Requete 12
Nombre de sorties de l'artiste chantant Highway to Hell.
178
Fiche 3:
-SELECT DISTINCT song_name FROM songs INNER JOIN singers ON singers.id = songs.artist WHERE singers.name="Rage Against The Machine" LIMIT 10;
-SELECT song_name FROM songs INNER JOIN singers ON singers.id = songs.artist AND songs.release_date != "" WHERE singers.name="The Police" LIMIT 0, 1;
-SELECT singers.name FROM singers INNER JOIN data ON data.id = singers.id WHERE data.followers = (SELECT max(data.followers) FROM data);
-SELECT DISTINCT data.num_release FROM data INNER JOIN songs ON songs.artist = data.id WHERE songs.song_name = "Highway to hell";
