A table where x,y and z have some individual amounts like image1.
Now I want to show a table where each 'name' will have one row with the summation of it's multiple rows of values in the same date like image 2.
So what is the laravel query for that?