I äm trying to create a new lobby for Project Hour and Cost Analysis hence I have created the below sql query but I am finding it difficult to have a sub-total for every group of the same activity

I wrote the following SQL query 

select distinct

a.activity_description,

a.resource_id as resource_id,

b.resource_group_desc,

a.qty_used as qty_used,

a.qty_planned as qty_planned,

a.project_cost,

a.percent_used

from IFSAPP.activity_resource_proj a JOIN IFSAPP.activity_resource_proj_sum b

ON a.resource_id = b.resource_id

AND a.project_id = '&Project_ID'

ORDER BY activity_description

Below is what I am gettting:

I need a sub_total for Activity named 'DETAILED DESIGN’ as well as sub_total for '’ÍNSTALLATION SAFETY STUDIES'’