题解 | 统计用户获得积分
select user_id,FLOOR(sum(TIMESTAMPDIFF(MINUTE,visit_time,leave_time)/10 ) )point from visit_tb group by user_id order by point desc
select user_id,FLOOR(sum(TIMESTAMPDIFF(MINUTE,visit_time,leave_time)/10 ) )point from visit_tb group by user_id order by point desc
相关推荐