Interview Query

Risk Analyst | September 2020

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

0 Comments

Sort By: Default

Edit Post

Tag your post (e.g. "Amazon", "Data Scientist" ...)

Preview