验证结果
-
通过 ClickHouse连接工具登录 ClickHouse。
-
执行以下命令，查询从
2022-01-18 00:00:00开始，消费 Top 3 的用户及消费总金额。select supplier, SUM(price) as total from top_price where start > '2022-01-18 00:00:00' group by supplier order by total desc limit 3;
通过 ClickHouse连接工具登录 ClickHouse。
执行以下命令，查询从 2022-01-18 00:00:00 开始，消费 Top 3 的用户及消费总金额。
select supplier, SUM(price) as total
from top_price
where start > '2022-01-18 00:00:00'
group by supplier
order by total desc limit 3;