题解 | 统计用户获得积分
统计用户获得积分
https://www.nowcoder.com/practice/22ed0cd240824bb597b3130fef389cea
select user_id, sum(floor(timestampdiff(minute, visit_time, leave_time)/10)) point from visit_tb group by user_id order by point desc
统计用户获得积分
https://www.nowcoder.com/practice/22ed0cd240824bb597b3130fef389cea
select user_id, sum(floor(timestampdiff(minute, visit_time, leave_time)/10)) point from visit_tb group by user_id order by point desc
相关推荐
找工作勤劳小蜜蜂:矛盾是没有实习,就是没实战经验,公司不想要,公司不要,你就没有实习,你就进入死循环,另外你的项目不是社会现在有大量岗位存在行业用的,云存储人员早就饱和。