SELECT ID, COUNT(ACCOUNT_ID), SUM(PAYMENT_AMOUNT) FROM (SELECT P.PAYMENT_TYPE IN ('INFLOW')), SUM(P.PAYMENT_AMOUNT) FROM (SELECT P.PAYMENT_TYPE IN ('OUTFLOW'))
      FROM PAYMENTS
      GROUP BY ID
      HAVING PAYMENT_AMOUNT>=5000
      WHERE EXTRACT(MONTH_DAY FROM date_created) = EXTRACT(MONTH_DAY FROM CURDATE() - INTERVAL 1 MONTH);

SELECT DISTINCT A.ID, COUNT(P.ACCOUNT_ID), SUM(P.PAYMENT_AMOUNT)
     FROM ACCOUNT A
     INNER JOIN PAYMENTS P
     GROUP BY A.ID
     HAVING A.ID=P.ID
     WHERE P.PAYMENT_AMOUNT>=5000 AND PAYMENT_DATE >= (SELECT NOW() - INTERVAL 1 MONTH);