• SELECT CODE, COUNT(Name) AS Name

    FROM TABLENAME

    GROUP BY CODE