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