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