select 
course_name,
round(avg(timestampdiff(second,in_datetime,out_datetime)/60),2) as avg_Len

from course_tb c
join attend_tb a
on c.course_id = a.course_id

group by course_name

order by avg_Len desc

别忘了avg