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
Preview:
downloadDownload PNG
downloadDownload JPEG
downloadDownload SVG
Tip: You can change the style, width & colours of the snippet with the inspect tool before clicking Download!
Click to optimize width for Twitter