SELECT

            date_format(examinee_pay_time, '%Y-%m-%d') as payDate,

            COUNT(examinee_id) As realityApplyCount, <!-- 日缴费次数 -->

            sum((CASE WHEN examinee_exam_score IS NULL THEN exam_fee ELSE  END )) as realityApplyFee, <!-- 日缴费金额 -->

            exam_id,

            exam_name,

            examinee_pay_status,

            examinee_exam_status

        FROM

            schoolexam

        INNER JOIN examinee e ON exam_id = exam_item_id    AND  exam_type = examinee_apply_type

                                    AND (examinee_exam_status != '' OR ISNULL(examinee_exam_status))

                                    AND examinee_pay_status = ""

        <where>

             =

        </where>

        GROUP BY

            date_format(examinee_pay_time, '%Y-%m-%d')