select
	course_name,
	round(avg(timestampdiff(minute, in_datetime, out_datetime)),2) as avg_Len
from attend_tb
join course_tb
	using (course_id)
group by course_name
order by avg_Len desc