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 |