Interview Questions
Interview Guides
Experiences
Explore
Get started
Sign in
Interview Guides
All questions
/
SQL & Data Manipulation
Top Assets Per Portfolio Query
Medium
Asked at 1 company
Window Functions
Date Functions
Ranking
Problem
Write a SQL query to find the top three performing assets in each portfolio over the last quarter.
Question
Answer
Problem
Write a SQL query to find the top three performing assets in each portfolio over the last quarter.
Your answer
Edit
Preview
Try one AI text evaluation on us
Get structured feedback, scored against a 4-axis rubric. Premium unlocks unlimited.
0 words
target ~200
Try a free preview
Stuck? Get a hint
Past attempts
Up next
Top Recovery Portfolios SQL
Medium
Top Assets per User
Medium
SQL Top Quartile YoY Growth
Medium
Next question
Top Assets Per Portfolio Query | Dataford Interview Questions