题解 | 统计用户获得积分
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
相关推荐