SQLize Online / PHPize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
CREATE TABLE t ( product char, position char, count INT ); INSERT into t values ('onion', 'in', 10), ('onion', 'out', 3), ('cucumber', 'in', 30), ('carrot', 'in', 23), ('onion', 'out', 7), ('cucumber', 'out', 12), ('potato', 'in', 80), ('onion', 'in', 21), ('cabbage', 'in', 35), ('carrot', 'out', 12), ('cabbage', 'out', 3), ('mango', 'in', 25), ('onion', 'out', 3), ('potato', 'out', 10), ('apple', 'in', 45), ('cabbage', 'out', 20), ('cucumber', 'in', 81), ('apple', 'out', 7), ('mango', 'in', 13); SELECT product, SUM(count) FROM t GROUP BY product;
Stuck with a problem? Got Error? Ask ChatGPT!
Copy Clear