explain ddl SELECT count(c.id) FROM customers c INNER JOIN orders o ON (c.id = o.cid) GROUP BY c.id;