Requête qui totalise selon des critères ?

SELECT annee, presta, SUM(T.total) AS ca_total
        FROM (
            SELECT compositions.prix*compositions.quantites AS total, YEAR(contrat.date_debut) as annee,
              CASE
                WHEN prestations.type = 3 THEN 3
                ELSE 9
              END AS presta
            FROM compositions
            INNER JOIN contrats
            ON compositions.id_contrat=contrats.id_contrat
            INNER JOIN prestations
            ON prestations.id_prestation = compositions.id_prestation
            WHERE contrats.etat =3
            ) AS T
GROUP BY annee, presta 

SELECT  ANNEE
      , T.P_TYPE 
      , SUM(T.total) AS ca_total
FROM (
    SELECT C.prix*C.quantites AS total
          ,CA.etat
          , YEAR(CA.date_debut) as ANNEE  
          , IF (P.type = 3 , 'TYPE3', 'TYPEAUTRE') as P_TYPE
    FROM compositions C
    INNER JOIN contrats CA  ON C.id_contrat=CA.id_contrat
    INNER JOIN prestations P  ON P.id_prestation = C.id_prestation
  ) AS T
WHERE T.etat=3 
GROUP BY  T.ANNEE, T.P_TYPE
ORDER BY T.ANNEE DESC
            

// Connexion à la bdd :
    require('connexion.php');

    $requete1 = $bdd->query('
        SELECT  ANNEE, T.P_TYPE, SUM(T.total) AS ca_total
        FROM (
            SELECT C.prix*C.quantites AS total,CA.etat, YEAR(CA.date_debut) as ANNEE, IF (P.type = 3 , \'RESTAURATION\', \'HEBERGEMENT\') as P_TYPE
            FROM compositions C
            INNER JOIN contrats CA  ON C.id_contrat=CA.id_contrat
            INNER JOIN prestations P  ON P.id_prestation = C.id_prestation) AS T
        WHERE T.etat=3
        GROUP BY  T.ANNEE, T.P_TYPE
        ORDER BY T.ANNEE ASC
    ');
    
    while ($data = $requete1->fetch()) {
        // Hébergement : 
        if($data['P_TYPE']=="HEBERGEMENT")    
        $hebergement = array(
            array("label"=> $data['ANNEE'], "y"=> $data['ca_total']),
        );
       

        // Restauration : 
        if($data['P_TYPE']=="RESTAURATION")    
        $restauration = array(
            array("label"=> $data['ANNEE'], "y"=> $data['ca_total']),
        );
    }

while ($data = $requete1->fetch()) {
        // Hébergement : 
        if($data['P_TYPE']=="HEBERGEMENT"){    
            $hebergement[] = array(
                array("label"=> $data['ANNEE'], "y"=> $data['ca_total']),
            );
        }

        // Restauration : 
        if($data['P_TYPE']=="RESTAURATION"){    
            $restauration[] = array(
                array("label"=> $data['ANNEE'], "y"=> $data['ca_total']),
            );
        }
    }

<?php
 
$dataPoints = array(
	array("label"=> "Core 1", "y"=> 20),
	array("label"=> "Core 2", "y"=> 65),
	array("label"=> "Core 3", "y"=> 11),
	array("label"=> "Core 4", "y"=> 5),
	array("label"=> "Core 5", "y"=> 48),
	array("label"=> "Core 6", "y"=> 8),
	array("label"=> "Core 7", "y"=> 2),
	array("label"=> "Core 8", "y"=> 18)
);
 
?>