RFI 1

SELECT A.merchant_id, A.max_for_previous_month, A.max_for_current_month, ((A.max_for_current_month - A.max_for_previous_month )/ A.max_for_current_month) as percent_jump, B.final_merchant_classification
	FROM	
	(
		(SELECT merchant_id
			, max(case when month = 3  then max_amount else 0 end) as max_for_previous_month
			, max(case when month = 4  then max_amount else 0 end) as max_for_current_month
		FROM fraud.merchant_rfi_master_table_test
		group by merchant_id
		)A
	inner join
        (select merchant_id, final_merchant_classification
        from fraud.fra_rbi_hml_final
        WHERE final_merchant_classification = 'H'
        group by merchant_id, final_merchant_classification)B
    ON A.merchant_id = B.merchant_id
    )
	where A.max_for_previous_month > 24000 and A.max_for_current_month > 24000 and  ((A.max_for_current_month - A.max_for_previous_month )/ A.max_for_current_month)>0.75