fork download
copy 
  1. Create table hoge(name text primary key, suryo int, tanka int);
  2. Insert into hoge values ('apple', 3, 120), ('orange', 2, 140), ('peach', 1, 100);
  3. Select name, sum(suryo * tanka) as '総和' from hoge group by name;
  4.  
Success #stdin #stdout 0s 4532KB
comments (?)
stdin
copy 
Standard input is empty
stdout
copy 
apple|360
orange|280
peach|100
https://ideone.com/bIMSux
language:
SQLite (sqlite 3.27.2)
created:
5 years ago
visibility:
public

Share or Embed source code

Discover > Sphere Engine API

The brand new service which powers Ideone!

Discover > IDE Widget

Widget for compiling and running the source code in a web browser!