编辑代码

create table register (
    id integer primary key,
    name text not null,
    area char(20) not null,
    number integer not null,
    belong char(20) not null
);

insert into register values (36829763,'fortle','A1082',032,'C36');
insert into register values (45677989,'carmy','B1083',793,'D32');
insert into register values (99999999,'...','Z9999',999,'D32');

select * from register group by belong;