Update parent status based on all children status and sum of children amount.

Thank You for the response Jason. Table 2 is related to table 3 via reference column.

5654471 4336620 - In this 4336620 is the ID of table 2. We need to parse the column when joining.