SQLize Online / PHPize Online  /  SQLtest Online

create table test ( name varchar, number integer, currency integer ); insert into test values ('name1', '1', '1'); insert into test values ('name1', '2', '1'); insert into test values ('name1', '3', '2'); insert into test values ('name1', '4', '2'); insert into test values ('name2', '1', '1'); insert into test values ('name2', '2', '1'); insert into test values ('name2', '3', '2'); select name, (select json_agg(rows) from( select sum(number) as sum_number from test as subtest where subtest.name = test.name group by currency ) as rows) as prof from test group by test.name