SELECT vol.id, vol.codfisc
, GROUP_CONCAT(vol.qualifica ORDER BY vol.qualifica DESC SEPARATOR '|') AS qualifica
, COUNT(*) as tot 
FROM z_dump_volontari AS vol
GROUP BY vol.codfisc, vol.qualifica
order by tot desc