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