Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- select DISTINCT ON (user_id, submittedat)
- id
- , user_id
- , (appliedloandata->'amount')::float
- , outcome
- , declinereason
- , decisionruledata->'score_Jesse$VJ2Score' AS VJ2Score
- , decisionruledata->'score_Jesse$VJScore' AS VJScore
- , decisionruledata->'score_Jesse$VJ2AndLoanAmountRegressionScore' AS VJ2Regression
- , decisionruledata->'score_Jesse$VJAndLoanAmountRegressionScore' AS VJRegression
- , decisionruledata->'VJRandomResearch' AS vj_random_research
- from credit_applications
- where user_id in (
- select user_id
- from experiment_records
- where source = 'LENDUP'
- and experiment_source_id = '1'
- and experiment_variant_source_id = '4' limit 229
- )
- and (appliedloandata->'amount')::float > 250
- and submittedat IS NOT NULL
- ORDER BY user_id, submittedat;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement