本文共 433 字，大约阅读时间需要 1 分钟。

题目：（简单）

标签：SQL

解法一：

SELECT '[0-5>' AS bin,       COUNT(*) AS totalFROM SessionsWHERE duration BETWEEN 0 AND 299UNIONSELECT '[5-10>',       COUNT(*)FROM SessionsWHERE duration BETWEEN 300 AND 599UNIONSELECT '[10-15>',       COUNT(*)FROM SessionsWHERE duration BETWEEN 600 AND 899UNIONSELECT '15 or more',       COUNT(*)FROM SessionsWHERE duration >= 900;

转载地址：https://dataartist.blog.csdn.net/article/details/110424256 如侵犯您的版权，请留言回复原文章的地址，我们会给您删除此文章，给您带来不便请您谅解！