drop table if exists cli, prod;

create table cli (idcliente int);
create table prod (idprodotto int);

select count(c.*), (SELECT count(p.*) FROM prod p)) FROM cli c;