Create table hoge(name text primary key, suryo int, tanka int);
Insert into hoge values ('apple', 3, 120), ('orange', 2, 140), ('peach', 1, 100);
Select name, sum(suryo * tanka) as '総和' from hoge group by name;
Q3JlYXRlIHRhYmxlIGhvZ2UobmFtZSB0ZXh0IHByaW1hcnkga2V5LCBzdXJ5byBpbnQsIHRhbmthIGludCk7Ckluc2VydCBpbnRvIGhvZ2UgdmFsdWVzICgnYXBwbGUnLCAzLCAxMjApLCAoJ29yYW5nZScsIDIsIDE0MCksICgncGVhY2gnLCAxLCAxMDApOwpTZWxlY3QgbmFtZSwgc3VtKHN1cnlvICogdGFua2EpIGFzICfnt4/lkownIGZyb20gaG9nZSBncm91cCBieSBuYW1lOwo=