SELECT
    ROUND(SUM(paymentAmount),2) as totalRefferedRevenue

FROM

payments p

WHERE
    userID IN (
            SELECT
                    userID

            FROM
                users

            WHERE
                userReferrerUserID IS NOT NULL
                AND userReferrerUserID <> 999999999)