Oracle 11g Release 2

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

create table sidewalk_deficiency (
    def_id number(10), 
    insp_id number(10),
    def_length number(10,2));
insert into sidewalk_deficiency values (10,1,.5);
1 rows affected

insert into sidewalk_deficiency values (11,1,1);
1 rows affected

insert into sidewalk_deficiency values (12,1,1.5);
1 rows affected

insert into sidewalk_deficiency values (13,2,2);
1 rows affected

insert into sidewalk_deficiency values (14,2,2.5);
1 rows affected

select 
    insp_id, def_length
from 
    sidewalk_deficiency 
group by 
    insp_id,
    def_length 


INSP_ID
DEF_LENGTH


2
2.5

1
.5

1
1

2
2

1
1.5


insert into sidewalk_deficiency values (14,2,2.5);
1 rows affected

select 
    insp_id, def_length, sum(def_length) as sm
from 
    sidewalk_deficiency sd
group by 
    insp_id,
    def_length 


INSP_ID
DEF_LENGTH
SM


2
2.5
5

1
.5
.5

1
1
1

2
2
2

1
1.5
1.5