with t1 as( select user_id, course_id, if_sign, round(sum(timestampdiff(second,in_datetime,out_datetime))/60,1) onlinetime from attend_tb right join behavior_tb using(user_id,course_id) group by user_id,course_id,if_sign ) select course_id, co...