select course_name,round(sum(timestampdiff(second,in_datetime,out_datetime))/60/count(1),2) avg_Len
from
course_tb join attend_tb using(course_id)
group by course_name
order by avg_Len desc