题解 | 统计用户获得积分
select user_id, floor(sum(timestampdiff(minute,visit_time,leave_time))/10) as point from visit_tb group by user_id order by point desc
知识点:floor函数,向下取整
select user_id, floor(sum(timestampdiff(minute,visit_time,leave_time))/10) as point from visit_tb group by user_id order by point desc
知识点:floor函数,向下取整
相关推荐