lyrixx's questions

我有以下代码：

drop table if exists statusCodes;

create table statusCodes (statusCode UInt16) engine=Memory;

insert into statusCodes values (0);
insert into statusCodes values (200);
insert into statusCodes values (200);
insert into statusCodes values (200);
insert into statusCodes values (200);
insert into statusCodes values (200);
insert into statusCodes values (201);
insert into statusCodes values (301);
insert into statusCodes values (301);
insert into statusCodes values (301);
insert into statusCodes values (301);
insert into statusCodes values (304);
insert into statusCodes values (404);
insert into statusCodes values (500);

select
    multiIf(statusCode >= 500, '5xx', statusCode >= 400, '4xx', statusCode >= 300, '3xx', statusCode >= 200, '2xx', 'errored'),
    groupArray(statusCode),
    count(1) as count
from statusCodes
group by 1;

在这里小提琴：https://fiddle.clickhouse.com/b3b3dfb9-1826-47a8-b201-831498c941f2

它给了我

但我想要有类似的东西

因此，总而言之，我想按主类别（2xx、3xx、4xx、5xx）对所有状态代码进行分组，并在行中按该类别的实际状态代码进行另一个分组。