Interview Query

Risk Analyst | September 2020

S
[email protected]April 5, 2021
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

There are no comments yet. Start the conversation by leaving a comment.

Related posts

JP Morgan Chase Senior Quantitative Analyst | October 2021
Florida Power & Light Mid-Level Data Scientist | May 2022
Capital One Manager Data Science Manager | November 2021
Asurion Senior Quantitative Analyst | March 2021