create table ledger
(id integer, balance integer,
note text);
insert into ledger values
(1, 100, 'ス2/21');
insert into ledger values
(2, 200, 'ス11/21');
insert into ledger values
(1, 110, '');
insert into ledger values
(2, 220, '');
.headers on
.mode csv
select id, sum(balance) as sum from ledger
group by id;
Y3JlYXRlIHRhYmxlIGxlZGdlcgogIChpZCBpbnRlZ2VyLCBiYWxhbmNlIGludGVnZXIsCiAgICBub3RlIHRleHQpOwppbnNlcnQgaW50byBsZWRnZXIgdmFsdWVzCiAgICAoMSwgMTAwLCAn44K5Mi8yMScpOwppbnNlcnQgaW50byBsZWRnZXIgdmFsdWVzCiAgICAoMiwgMjAwLCAn44K5MTEvMjEnKTsKaW5zZXJ0IGludG8gbGVkZ2VyIHZhbHVlcwogICAgKDEsIDExMCwgJycpOwppbnNlcnQgaW50byBsZWRnZXIgdmFsdWVzCiAgICAoMiwgMjIwLCAnJyk7CgouaGVhZGVycyBvbgoubW9kZSBjc3YKc2VsZWN0IGlkLCBzdW0oYmFsYW5jZSkgYXMgc3VtIGZyb20gbGVkZ2VyCiAgICBncm91cCBieSBpZDsKCgoKCgoKCgoK