1：如果不考虑当天刚开始是关播或者连续的关播，当天最后是开播或者连续的开播 select id,sum(length) as all_time ...

table : user 字段：uid begin end select uid,sum(time) as all_time from (sel...