Pasted

SELECT DISTINCT
Count(cpa.RECEIPT_NO) AS `Refs No.`,
cpa.RECEIPT_NO AS `Ref No.`,
cpa.PAYMENT_DATE AS Date,
CONCAT(cli.PREFIX_NAME,cli.FIRST_NAME_EN,' ',cli.LAST_NAME_EN) AS `Student Name`,
gn.`NAME` AS `Group Name`,
cos.`NAME` AS `Course Name`,
rct.NAME_EN AS `Course Type`,
cpa.PAYMENT_PRICE AS Amount,
gn.LESSON_TOTAL AS `Total Lesson`,
Count(casbook.ID) AS Lesson_PER_MONTH,
(cpa.PAYMENT_PRICE/gn.LESSON_TOTAL) AS `Bath/Lesson`,
(cpa.PAYMENT_PRICE/gn.LESSON_TOTAL)*Count(casbook.ID) AS `Bath/Month`,
casbook.GROUP_ID,
YEAR(casbook.DATE),
MONTH(casbook.DATE)
FROM
client_payment_amount AS cpa
LEFT JOIN client AS cli ON cpa.CLIENT_ID = cli.ID
LEFT JOIN group_register AS gr ON gr.CLIENT_ID = cli.ID
LEFT JOIN group_name AS gn ON gr.GROUP_ID = gn.ID
LEFT JOIN course AS cos ON gr.COURSE_ID = cos.ID
INNER JOIN ref_course_type AS rct ON gr.COURSE_TYPE_ID = rct.ID
INNER JOIN classroom_book AS casbook ON casbook.GROUP_ID = gn.ID
GROUP BY
cpa.RECEIPT_NO,
casbook.GROUP_ID,
YEAR(casbook.DATE),
MONTH(casbook.DATE)
ORDER BY
cpa.RECEIPT_NO,
casbook.DATE