SELECT
    userSMSRefill,
    count(DISTINCT p.userID) usersCount,
    ROUND(SUM(paymentAmount)) revenue

FROM
    payments p
    LEFT JOIN users u
    on p.userID = u.userID

WHERE

paymentDateTime > '2022-07-13 00:00:01'
AND p.userID IN (
    SELECT
                 userID
                FROM
                        alertcontacts

                WHERE
                        alertContactType IN (8,14)
                        AND alertContactStatus = 2

                GROUP BY
                                userID
                ORDER BY
                        userID)
AND paymentPeriod = 0

GROUP BY
    userSMSRefill