Rule 10

SELECT A.receiveruser, A.totAmt, A.txn_count, A.active_days, A.sender_cnt, C.merchant_acquisition_date, C.merchant_activation_date FROM
    (SELECT receiveruser, SUM(totaltransactionamount) as totAmt, count(distinct transaction_id) as txn_count, COUNT(DISTINCT updated_date) as active_days
    , COUNT(DISTINCT senderuserid) AS sender_cnt
    FROM fraud.transaction_details_v3 
    WHERE updated_date BETWEEN '2023-01-01' AND '2023-01-31'
    AND backend_errorcode = 'SUCCESS' AND errorcode = 'SUCCESS' AND pay_transaction_status = 'COMPLETED'
    AND receivertype = 'MERCHANT'
    GROUP BY receiveruser)A
LEFT JOIN
    (SELECT DISTINCT receiveruser
    FROM fraud.transaction_details_v3 
    WHERE updated_date BETWEEN '2023-02-01' AND '2023-02-28'
    AND backend_errorcode = 'SUCCESS' AND errorcode = 'SUCCESS' AND pay_transaction_status = 'COMPLETED'
    AND receivertype = 'MERCHANT')B
ON A.receiveruser = B.receiveruser
INNER JOIN
    (SELECT merchant_id, merchant_acquisition_date, merchant_activation_date
    FROM fraud.fra_merchant_dimension
    WHERE merchant_acquisition_date BETWEEN '2023-01-01' AND '2023-01-31' 
    AND merchant_activation_date BETWEEN '2023-01-01' AND '2023-01-31'    
    AND blacklisted = 0)C
ON A.receiveruser = C.merchant_id
WHERE B.receiveruser IS NULL 
ORDER BY A.totAmt DESC
HAVING A.totAmt > 200000