Pranjal Verma pvcodes
pvcodes
/ gist:618e1d1b27f745074f0493643b2ed1d1
Created
August 22, 2025 05:27
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| WITH osh_ranked AS ( | |
| SELECT | |
| customer_id, | |
| ca_credit_turnover_amt AS osh_ca, | |
| eff_start_date, | |
| eff_end_date | |
| FROM ( | |
| SELECT | |
| customer_id, | |
| ca_credit_turnover_amt, |