Query to retrieve parent-child aggregate records

thank you very much this helped me