SELECT 
    score_weekNum AS weekNumber, 
    score_weekRange, 
    COUNT(*) AS nb_parcours_joues, -- Compte le nombre de parties de 9 trous dans la semaine
    SUM(score_stroke) AS total_stroke, 
    SUM(score_STBb) AS total_STBb,
    SUM(score_STBn) AS total_STBn,
    -- 1. Ton ratio précédent : STBb par trou joué
    ROUND(SUM(score_STBb) / SUM(score_nbofholes), 2) AS ratio_STBb_per_hole,
    -- 2. Ta nouvelle demande : Cumul STBb divisé par le nombre de parcours joués
    ROUND(SUM(score_STBb) / COUNT(*), 2) AS avg_STBb_per_parcours
FROM golf_scores
WHERE YEAR(score_date) = 2025 
  AND score_nbofholes = 9 
GROUP BY score_weekNum, score_weekRange
ORDER BY CAST(score_weekNum AS UNSIGNED) ASC;