// on affiche les albums du chanteur
SELECT * FROM albums WHERE id_chanteur = id

// on calcule le total des ecoutes <====== Cette requete je veu l'eviter par la suivante
SELECT SUM() FROM chansons ....

UPDATE de l'album et de la chanson en meme temps (une seule requete)

un select les champs albums, select count(*) from chanson where idalbum = ab.idalbum as nbtitre, select sum(nbvue) from chanson where idalbum = ab.idalbum as nbecoute, etc
from albums ab

SELECT albums.id,albums.album, sum(chansons.play) AS total_play FROM albums
INNER JOIN chansons ON chansons.id_album = albums.id
WHERE id = id

SELECT * FROM albums WHERE id_chanteur = id
//on affiche les donnees

SELECT SUM() FROM chansons ....

select sum(play) from chansons;

Table albums
id
album
total_play

Table chansons
id
id_album
chanson
play

// chansons
UPDATE chansons SET play = play + 1 WHERE id = id

// albums
UPDATE albums SET total_play = total_play + 1 WHERE id = id