I would like to add to my query a count field, and I have no idea how…. the desired results is :
name |count ———- xxx | 1 yyy | 2 zzz | 3
or
name | count ———— zzz | 1 xxx | 2 yyy | 3
