SELECT
    YEAR(paymentDateTime) AS year,
    MONTH(paymentDateTime) AS month,
    paymentPeriod,
    COUNT(DISTINCT userID) customersWithPayment,
    ROUND(SUM(paymentAmount),2) revenue

FROM
    payments

WHERE
    paymentStatus = 1
    AND paymentType = 2

GROUP BY
    year, month, paymentPeriod

ORDER BY
    year DESC,
    month DESC