I have tried this & it works well.....

when firstname,lastname and date are same then

definately it groups the grades and give the avearage result.

select firstname, lastname, date,avg(grades)

from duplicate2

group by firstname, lastname,date