modify a query to return total or count per branch.

hello expert,

I have this query below,

I am attempting to return a total per branch but i am struck.

Below the query is result i getting

Could please modify the query so that a count is return per branch ( like breaking on branch

and showing the total user in that branch)

spool user.txt
column num1 format 9999999 heading "Branch"
set head on
break on report by org_code
compute sum of num1 on report
select
substr(org_code,1,12) num1
,user_id,user_name
from users where inhib_acc ='N'
and deleted is null
and org_code in ('01','02','03','05','06','04')
group by org_code,user_id,user_name



02     ANGPER         ANGELIA PERSAUD
03     AMAEZZ         AMALLIA EZZARD
 
Branch USER_ID        USER_NAME
------ -------------- -----------------------------------
03     ENGFLE         ENGLEBERT FLEMING
03     ERIJOH         ERIC JOHNSON
03     GLEMIN         GLENISS MINGO
03     MADWEB         MADONNA R WEBSTER
03     NEESIN         NEETU SINGH
03     TRIPER         TRICEA PERSAUD
03     WALSEE         WALTER P SEETRAM
04     JERSIN         JEREMY SINGH
04     KEVMAC         KEVIN IAN MACKLINGAM
04     SARBHI         SAROJNE BHIM
04     SHAMAH         SHAKUNTALA MAHASE
 
Branch USER_ID        USER_NAME
------ -------------- -----------------------------------
05     AMEJAG         AMEENA JAGNARAYAN
05     GUWJAI         GUWANTIE JAINARAIN
05     RAYRAM         RAYMOND RAMDATT
05     SEWRAG         SEWCHAN  RAGHUNANDAN
05     TAJSIV         TAJWATTIE SIVIRAM
06     RAMJAG         RAMESHWAR JAGERNAUTH
06     RANPER         RANA PERSAUD
06     ROSGAJ         ROSANNA GAJADAR
06     SUKBAC         SUKAISHANIE BACHAN


NOTE BECAUSE OF THE VOLUME OF INFO RETEURN I JUST INCLUDED A SUBSET OF THE USERS

FOR GUILDANACE

Start Free Trial