SQL group by between

Question

我有下面的SQL代码

SELECT user_id, COUNT(*) 
FROM crate_log 
GROUP BY user_id, last_crate - first_crate 
HAVING COUNT(*) > 1 
ORDER BY COUNT(*) DESC

我想要做的是得到"last_crate - first_crate“5向上和向下5的所有结果，并对它们进行计数。

像这样：

last_crate - first_crate BETWEEN last_crate - first_crate - 5 
                             AND last_crate - first_crate + 5

我试过几件事，但不知道怎么做。

顺便说一句。

last_crate - first_crate

就是我所需要的区别

希望你能理解我..

Answer 1

怎么样

SELECT user_id, last_crate - first_crate, COUNT(*) 
FROM crate_log 
GROUP BY user_id, last_crate - first_crate 
HAVING COUNT(*) > 1 AND ABS(last_crate - first_crate)<=5
ORDER BY COUNT(*) DESC