Practice with the full bank, then narrow into a path.
Your active path is foundations track, but the catalog stays broad by default so you can spot harder reps, switch contexts quickly, and still return to the path that best matches your current goal. Starter includes 160 free problems and marks 94 Pro-only problems before you open a gate.
Start broad, then focus when you want structure.
Company labels help frame practice in a familiar business context. They are directional study aids, not official interview guidance from the companies listed. We keep all paths visible first so hard questions do not disappear.
· 94 Pro problems · Filter:
Company
Difficulty
Path
Browse first, then sign in when you want to run SQL.
Free problems open for practice. Pro unlocks the full bank, study plan, and mock interviews.
IshaSQL Pro — 30-day pass
₹999
30 days of Pro access. Renew or extend anytime; extra time stacks from your current end date.
IshaSQL Pro — annual pass
₹7,999
365 days of Pro access. Renew or extend anytime; extra time stacks from your current end date.
8+ months free vs buying 30-day passes.
Spotify
Foundations Track
Sponsor Payback Ratio
Finance wants a simple efficiency metric for podcast sponsors. For each sponsor_id, return the ratio of total attributed_revenue to total media_spend rounded...
Spotify
Foundations Track
Year-on-year Product Spend Growth
At Spotify, analysts are preparing a scorecard focused on year-on-year product spend growth. Calculate the year-on-year growth rate for each product_id. Retu...
Spotify
Foundations Track
Most Frequent Item Counts
Spotify is reviewing most frequent item counts through a operations review. Return the item_count value or values with the highest order_occurrences. Sort by...
Spotify
Foundations Track
2024 App Click Volume
At Spotify, analysts are preparing a readout focused on 2024 app click volume. Return each app_id and the total number of click events recorded in 2024. Sort...
Spotify
Foundations Track
Second-highest Salary
At Spotify, analysts are preparing a planning note focused on second-highest salary. Return the second-highest salary amount in the table as second_highest_s...
Spotify
Foundations Track
Creators With Multiple 2024 Posts
Use this Spotify ops memo to work on creators with multiple 2024 posts. Return each creator_id that posted at least two items in 2024. Sort by creator_id.
Spotify
Foundations Track
Departments Above Average Pay
Spotify wants a trend check for departments above average pay. Return each department_id whose average salary exceeds the company average salary for March 20...
Spotify
Foundations Track
Frequent Support Callers
Use this Spotify health check to work on frequent support callers. Return the distinct policy_holder_id values for members who made at least 3 calls. Sort by...
Spotify
Interview Core Track
3. What distinguishes an inner join from a full outer join
A full outer join returns all rows from both tables, including any unmatched rows, whereas an inner join only returns rows that match the join condition betw...
Spotify
Interview Core Track
1. Identify Spotify's Most Frequent Listeners
Spotify wants to identify their 'whale users', these are users who listen to the most tracks every month. They are potential customers to involve in user fee...
Spotify
Interview Core Track
8. Calculate the average listening duration for each music genre on Spotify
Suppose that Spotify would like to understand better the average listening duration for each genre of music on their platform. **Write a SQL query that calcu...
Spotify
Interview Core Track
Linkedin Power Creators (part 1)
Spotify wants a scorecard for linkedin power creators (part 1). Return each pair of products that were purchased together in the same order. Output product_i...
Spotify
Interview Core Track
Rolling Three-day Earnings
Use this Spotify planning note to work on rolling three-day earnings. Return each user_id, transaction_date, and rolling_3_day_earnings based on the current ...
Spotify
Interview Core Track
Products Bought Together
Spotify is reviewing products bought together through a trend check. Return each pair of products that were purchased together in the same order. Output prod...