I've below query ortho payments here I also want to filter by Payment Group currently I can able to filter by payment PayType SELECT SUM(amt) AS total_sum FROM ( SELECT payment.PayDate AS DatePay, MAX(CONCAT(patient.LName, ', ', patient.FName, ' ', patient.MiddleI)) AS lfname, GROUP_CONCAT(DISTINCT ...