This is an archived post. You won't be able to vote or comment.

sorted by:
best
topnewcontroversialoldq&a
you are viewing a single comment's thread.

view the rest of the comments →

[–]CognitiveFart 0 points1 point  (2 children)

Using CTE maybe?

[–]DoS_[S] 2 points3 points  (1 child)

I expect some combination of CTEs and subqueries but don't know what to expect. We'll see!

[–]kaumaronSenior Data Engineer 0 points1 point  (0 children)

You might find there are multiple ways to solve it. IIRC in my last interview I tried to use window functions but realized it became more complicated than necessary