题解 | 统计用户获得积分
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
相关推荐
LZStarV:冲就好了,就算真的是字节也冲,面评脏了大不了等三四个月就淡了,而且等到那个时候实力进步了选择还多,何必拘泥于字节