SELECT
    v.FA_CodeFamille,
    v.FamilleIntitule,
    COUNT(*) AS NbVentes
FROM F_DOCLIGNE l
JOIN F_ARTICLE a       ON a.cbAR_Ref = l.cbAR_Ref
JOIN V_ARTICLE_VERRE v ON v.AR_Ref = a.AR_Ref
GROUP BY v.FA_CodeFamille, v.FamilleIntitule
ORDER BY NbVentes DESC;