题解 | #牛客直播各科目平均观看时长#

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