I need to find the average on multiple fields for each id.
Given the data:
{id, maths, physics, english }
{CS001, 92, 85 , 76}
{CS002, 99, 75 , 66}
{CS003, 92, 85 , 76}
{CS004, 92, 85 , 76}
{CS001, 92, 85 , 76}
{CS002, 92, 85 , 76}
{CS003, 92, 85 , 76}
{CS004, 92, 85 , 76}
{CS001, 92, 85 , 76}
{CS002, 92, 85 , 76}
{CS003, 92, 85 , 76}
{CS004, 92, 85 , 76}
.
.
.
..
.
I need the output as the average of three fields for each of the member id
{CS001, 92, 85 , 76}
{CS002, 92, 85 , 76}
{CS003, 92, 85 , 76}
{CS004, 92, 85 , 76}
Please suggest.
Thanks !