Oracle 11g Release 2

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

create table CRIMES (CRIME_ID int, STATUS int)
insert all
into CRIMES values (1,100)
into CRIMES values (2,200)
into CRIMES values (3,100)
into CRIMES values (4,100)
into CRIMES values (5,300)
into CRIMES values (6,200)
into CRIMES values (7,300)
into CRIMES values (8,100)
into CRIMES values (9,200)
into CRIMES values (10,100)
select * from dual 
10 rows affected

SELECT    STATUS
         ,COUNT(CRIME_ID)
FROM      CRIMES
GROUP BY  STATUS;


STATUS
COUNT(CRIME_ID)


100
5

300
2

200
3


SELECT    AVG(COUNT(CRIME_ID)) "Avg # of Crimes per Status"
FROM      CRIMES
GROUP BY  STATUS;


Avg # of Crimes per Status


3.33333333333333333333333333333333333333