Maîtrise le SQL
du zéro à l'expert

-- Challenge #02 : Marché Sandaga
WITH ventes_ranked AS (
  SELECT
    v.vendeur_id,
    v.produit,
    SUM(v.quantite) AS total,
    RANK() OVER (
      PARTITION BY v.vendeur_id
      ORDER BY SUM(v.quantite) DESC
    ) AS rang
  FROM ventes_sandaga v
  GROUP BY v.vendeur_id, v.produit
)
SELECT * FROM ventes_ranked
WHERE rang <= 3;