SELECT
              live.batch_id,
              snap.upazilla_id,
              snap.upazilla_name,
              snap.session_id,
              snap.session_name,
              SUM(live.live_ben_count) AS live_ben_count,
              SUM(live.live_ben_student_count) AS live_ben_student_count,
              SUM(live.live_ben_amount) AS live_ben_amount,
              SUM(snap.beneficiary_count) AS snap_ben_count,
              SUM(snap.beneficiary_student_count) AS snap_ben_st_count,
              SUM(snap.beneficiary_amount) AS snap_ben_amount
            FROM
              (SELECT
                npy.batch_id,
                py.school_id,
                py.session_id,
                SUM(
                  CASE
                    WHEN (py.amount > 0)
                    THEN 1
                    ELSE 0
                  END
                ) AS live_ben_count,
                SUM(
                  CASE
                    WHEN (py.amount > 0)
                    THEN py.student_count
                    ELSE 0
                  END
                ) AS live_ben_student_count,
                SUM(
                  CASE
                    WHEN (py.amount > 0)
                    THEN py.amount
                    ELSE 0
                  END
                ) AS live_ben_amount
              FROM
                (SELECT
                  parent_id,
                  school_id,
                  batch_id
                FROM
                  noc_payment
                WHERE batch_id = 14
                GROUP BY school_id,
                  parent_id) AS npy
                INNER JOIN payment AS py
                  ON py.parent_id = npy.parent_id
                  AND py.school_id = npy.school_id
                INNER JOIN parent AS p
                  ON p.id = py.parent_id
              WHERE py.status != 'DELETED'
                AND py.session_id IN (5,6)
              GROUP BY py.school_id,
                py.session_id) AS live
              INNER JOIN school_wise_summary AS snap
                ON snap.school_id = live.school_id
                AND snap.session_id = live.session_id
                AND snap.batch_id = live.batch_id
            GROUP BY snap.upazilla_id,
              snap.session_id;