query

SELECT
    t_1.parent_id,
    t_1.school_id,
    t_2.dis_status,
    SUM(t_1.demand_amount) AS demand_amount,
    SUM(CASE
        WHEN (t_2.disbursed_amount IS NULL) THEN 0
        ELSE t_2.disbursed_amount
    END) AS disbursed_amount,
    SUM(CASE
        WHEN
            (t_2.dis_status = 'FAILED'
                AND t_2.disbursed_amount <> 0)
        THEN
            0
        WHEN (t_2.dis_status IS NULL) THEN 0
        ELSE t_1.demand_amount
    END) AS actual_disbursed_amount
FROM
    (SELECT
        parent_id, school_id, SUM(amount) AS demand_amount
    FROM
        pesp_db_local.payment
    WHERE
        school_id IN (SELECT
                id
            FROM
                school
            WHERE
                upazilla_id = 406)
            AND session_id IN (2 , 3)
    GROUP BY parent_id) AS t_1
        LEFT JOIN
    (SELECT
        dc.parent_id,
            dc.school_id,
            dc.status AS reg_status,
            fd.status AS dis_status,
            fd.amount AS disbursed_amount
    FROM
        disbursement_candidate_archive dc
    LEFT JOIN final_disbursement_archive fd ON (dc.school_code = fd.school_code
        AND dc.mobile = LEFT(wallet, 11))
    WHERE
        upazilla_id = 406) AS t_2 ON (t_1.parent_id = t_2.parent_id
        AND t_1.school_id = t_2.school_id)
-- WHERE
    -- t_1.school_id = 24043
GROUP BY t_1.school_id