Risk Analyst | September 2020

S
sindhureddy.195@gmail.comApril 5, 2021, 01:12 AM
Upvote
1
Downvote

Company: We pay

Position: Risk Analyst

Location: nan

Level: nan

Outcome: NA

How was the interview process? What was it like?

No

What technical questions were asked?

nan

What was one of your solutions?

With transactions as (
Select a.account-id, a.date, a.amount, rank() over(partition by account_id order by date desc) as latest_tran from 
(Select account-id, date, amount From checkout Where type = 8) as a
Left join (Select account-id, date, amount From checkout Where type = 9) as b
On a.account-id=b.account-id
And a.date < b.date
Where b.date is null) 
Select a.account-id, a.amount
From Transactions where latest_tran = 1

I
Ichimoku
Top comment
Lorem ipsum dolor sit amet, consectetur adipiscing elit
sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.

Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.

Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.
F
Fibonacci
Sit voluptatem accusantium doloremque laudantium, totam rem aperiam, eaque ipsa quae ab illo inventore veritatis et

quasi architecto beatae vitae dicta sunt explicabo. Nemo enim ipsam voluptatem quia voluptas sit aspernatur aut odit aut fugit, sed quia consequuntur magni dolores eos qui ratione voluptatem sequi nesciunt. Neque porro quisquam est
I
Ichimoku
Sed ut perspiciatis unde omnis iste natus error sit voluptatem accusantium doloremque laudantium 😀
F
Fibonacci
Sit voluptatem accusantium doloremque laudantium, totam rem aperiam, eaque ipsa quae ab illo inventore veritatis et

quasi architecto beatae vitae dicta sunt explicabo. Nemo enim ipsam voluptatem quia voluptas sit aspernatur aut odit aut fugit, sed quia consequuntur magni dolores eos qui ratione voluptatem sequi nesciunt. Neque porro quisquam est

Related posts

Amazon Manager Business Intelligence Manager | June 2021
UBS Senior Quantitative Analyst | April 2021
Bristol Myers Squibb Senior Research Scientist | March 2021
Amazon Entry Level Cloud Support Engineer Analytics | August 2022
There's so much more to Interview Query! Sign up to access hundreds of interview questions, expert coaching and a flourishing data science community.