How to calcuate each colume and display then make list

I'm studying laravel Scope.

Table name is "color" here is colum info

id |  colorname 
-----------------
1      black     
2      pink
3      blue
4      pink
5      green

I would like to calculate each 'colorname' amount and display list.

from Newest questions tagged laravel-5 - Stack Overflow https://ift.tt/2r5waxK
via IFTTT