/* List average grade given by instructor */

select lname, fname, avg(grade)  
from instructor join grade using(instructor_id)
group by lname, fname 
order by 1,2;