Colocar um count no meio de um baita select

Programação Java
#1

Alguém pode me ajudar como faço pra colocar um


select count (*) from cm_conn_period where module_id = '22433';

em


		sql.append("	select c.module_id  \n");
		sql.append("     , sum(c.mod_hours) mod_hours	\n");
		sql.append("     , sum(c.client_hours) client_hours	 \n");
		sql.append("     , (sum(mod_hours)/(24*"+ filter.getDateDif() +"))*100 mod_hours_porc	\n");
		sql.append("     , (sum(client_hours)/(24*"+ filter.getDateDif() +"))*100 client_hours_porc	\n");
		sql.append("     , r.ssn	\n");
		sql.append("     , r.name   \n");
		sql.append("     , nvl(sum(b.msg_count_from_mod), 0) msg_count_from_mod 	\n");
		sql.append("     , nvl(sum(b.msg_size_from_mod), 0) msg_size_from_mod 	\n");
		sql.append("     , nvl(sum(b.msg_count_to_mod), 0) msg_count_to_mod 	\n");
		sql.append("     , nvl(sum(b.msg_size_to_mod), 0) msg_size_to_mod 	\n");
		sql.append("   from cm_conn_period_sum c	\n");
		sql.append("     inner join rs_module r on (r.id_module = c.module_id)  \n");
		sql.append(" left join ( select ib.module_id, ib.msg_date		\n");
		sql.append("         , nvl(sum(ib.msg_count_from_mod), 0) msg_count_from_mod	\n");
		sql.append("         , nvl(sum(ib.msg_size_from_mod), 0) msg_size_from_mod	\n");
		sql.append("         , nvl(sum(ib.msg_count_to_mod), 0) msg_count_to_mod	\n");
		sql.append("         , nvl(sum(ib.msg_size_to_mod), 0) msg_size_to_mod	\n");
		sql.append("      from cm_billing_day ib inner join rs_module ir on (ib.module_id = ir.id_module)	\n");
		sql.append("     where 1 = 1	\n");

GRATO

#2 
		sql.append("	select c.module_id  \n");
		//colocando o count
		sql.append("     , (select count (*) from cm_conn_period where module_id = '22433')  \n");
		sql.append("     , sum(c.mod_hours) mod_hours	\n");
		sql.append("     , sum(c.client_hours) client_hours	 \n");
		sql.append("     , (sum(mod_hours)/(24*"+ filter.getDateDif() +"))*100 mod_hours_porc	\n");
		sql.append("     , (sum(client_hours)/(24*"+ filter.getDateDif() +"))*100 client_hours_porc	\n");
		sql.append("     , r.ssn	\n");
		sql.append("     , r.name   \n");
		sql.append("     , nvl(sum(b.msg_count_from_mod), 0) msg_count_from_mod 	\n");
		sql.append("     , nvl(sum(b.msg_size_from_mod), 0) msg_size_from_mod 	\n");
		sql.append("     , nvl(sum(b.msg_count_to_mod), 0) msg_count_to_mod 	\n");
		sql.append("     , nvl(sum(b.msg_size_to_mod), 0) msg_size_to_mod 	\n");
		sql.append("   from cm_conn_period_sum c	\n");
		sql.append("     inner join rs_module r on (r.id_module = c.module_id)  \n");
		sql.append(" left join ( select ib.module_id, ib.msg_date		\n");
		sql.append("         , nvl(sum(ib.msg_count_from_mod), 0) msg_count_from_mod	\n");
		sql.append("         , nvl(sum(ib.msg_size_from_mod), 0) msg_size_from_mod	\n");
		sql.append("         , nvl(sum(ib.msg_count_to_mod), 0) msg_count_to_mod	\n");
		sql.append("         , nvl(sum(ib.msg_size_to_mod), 0) msg_size_to_mod	\n");
		sql.append("      from cm_billing_day ib inner join rs_module ir on (ib.module_id = ir.id_module)	\n");
		sql.append("     where 1 = 1	\n");

Que tal?

#3