Aggregating counts on child of child

@Camway I am struggling with similar query, can you please post your query which helped to bring desired result. Thank you.