fork download
copy 
  1. CREATE TABLE t1 ( id integer );
  2. CREATE TABLE t2 ( id integer, id1 integer );
  3. INSERT INTO t1 VALUES(1);
  4. INSERT INTO t1 VALUES(2);
  5. INSERT INTO t2 VALUES(1, 1);
  6. INSERT INTO t2 VALUES(2, 1);
  7. INSERT INTO t2 VALUES(3, 1);
  8. SELECT t1.id,COUNT(t2.id) FROM t1 left JOIN t2 ON t1.id=t2.id1 group by t1.id;
Success #stdin #stdout 0s 3008KB
comments (?)
stdin
copy 
Standard input is empty
stdout
copy 
1|3
2|0
https://ideone.com/GHgKwD
language:
SQLite (sqlite 3.27.2)
created:
9 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!