/* List average grade obtained by student in order of highest grade */

select lname, fname, avg(grade) as GPA  
from student join grade using(student_id)
group by lname, fname 
order by 3 desc;