Insted use this query to get data & bind it with normal gridview
select group, min(score), avg(score),max(score)
from table
group by group
Add this event to yoour gridview
void Gridview1_RowDataBound(Object sender, GridViewRowEventArgs e)
{
if(e.Row.RowType == DataControlRowType.DataRow)
{
// cellno is column in which you score present
if( Convert.ToInt32(e.Row.Cells[cellno].Text) greterthan 70)
// use symbol insted of greterthan
{
e.Row.Style.Add("background","red");
}
}
}
Refer this link for color problem
Different row color in Gridview