题解 | SQLW22 统计用户获得积分
WITH t1 AS (
SELECT user_id,
FLOOR(SUM(TIMESTAMPDIFF(MINUTE ,
visit_time,leave_time)) / 10)
AS point
FROM visit_tb
GROUP BY user_id
)
SELECT * FROM t1
ORDER BY point DESC,user_id ASC;
# 这道题的关键在于FLoor(A/B)这个整除函数的使用！
查看2道真题和解析
