题解 | 统计用户获得积分
统计用户获得积分
https://www.nowcoder.com/practice/22ed0cd240824bb597b3130fef389cea
SELECT user_id, SUM(TRUNCATE(TIMESTAMPDIFF(MINUTE,visit_time,leave_time)/10,0)) as point FROM visit_tb GROUP BY user_id ORDER BY point DESC
统计用户获得积分
https://www.nowcoder.com/practice/22ed0cd240824bb597b3130fef389cea
SELECT user_id, SUM(TRUNCATE(TIMESTAMPDIFF(MINUTE,visit_time,leave_time)/10,0)) as point FROM visit_tb GROUP BY user_id ORDER BY point DESC
相关推荐