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