CREATE TABLE t1 ( id integer );
CREATE TABLE t2 ( id integer, id1 integer );
INSERT INTO t1 VALUES(1);
INSERT INTO t1 VALUES(2);
INSERT INTO t2 VALUES(1, 1);
INSERT INTO t2 VALUES(2, 1);
INSERT INTO t2 VALUES(3, 1);
SELECT t1.id,COUNT(t2.id) FROM t1 JOIN t2 ON t1.id=t2.id1 GROUP BY t2.id1;
Q1JFQVRFIFRBQkxFIHQxICggaWQgaW50ZWdlciApOwpDUkVBVEUgVEFCTEUgdDIgKCBpZCBpbnRlZ2VyLCBpZDEgaW50ZWdlciApOwpJTlNFUlQgSU5UTyB0MSBWQUxVRVMoMSk7CklOU0VSVCBJTlRPIHQxIFZBTFVFUygyKTsKSU5TRVJUIElOVE8gdDIgVkFMVUVTKDEsIDEpOwpJTlNFUlQgSU5UTyB0MiBWQUxVRVMoMiwgMSk7CklOU0VSVCBJTlRPIHQyIFZBTFVFUygzLCAxKTsKU0VMRUNUIHQxLmlkLENPVU5UKHQyLmlkKSBGUk9NIHQxIEpPSU4gdDIgT04gdDEuaWQ9dDIuaWQxIEdST1VQIEJZIHQyLmlkMTs=