Search ⌘K
Practice Workspace

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.

254 problems
160 free
94 Pro
393 company scenarios
34 hard reps visible
160 runnable on starter
0 solved so far
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.

9 visible
Hard 1
Medium 2
Easy 6
160 free problems

· 94 Pro problems · Filter:

Company
Difficulty
Path
Suggested path: Foundations Track
Pro feature
Free questions stay open
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
Best value
₹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.

Alibaba
Alibaba

Foundations Track

Asked at 11 companies
Easy
15 min
Second-highest Salary

Alibaba wants a readout for second-highest salary. Return the second-highest salary amount in the table as second_highest_salary.

Foundations Track
query basics
Alibaba
Alibaba

Foundations Track

Asked at 19 companies
Easy
15 min
Creators With Multiple 2024 Posts

At Alibaba, analysts are preparing a performance snapshot focused on creators with multiple 2024 posts. Return each creator_id that posted at least two items...

Foundations Track
query basics
Alibaba
Alibaba

Foundations Track

Asked at 20 companies
Easy
15 min
2024 App Click Volume

Alibaba wants a coverage check for 2024 app click volume. Return each app_id and the total number of click events recorded in 2024. Sort by app_id.

Foundations Track
query basics
Alibaba
Alibaba

Foundations Track

Asked at 20 companies
Easy
15 min
Frequent Support Callers

At Alibaba, analysts are preparing a priority review focused on frequent support callers. Return the distinct policy_holder_id values for members who made at...

Foundations Track
query basics
Alibaba
Alibaba

Foundations Track

Easy
15 min
Alibaba Compressed Mode

You're given a table containing the item count for each order on Alibaba, along with the frequency of orders that have the same item count. Write a query to ...

Foundations Track
filtering
aggregation
Alibaba
Alibaba

Foundations Track

Easy
15 min
15 Compressed Mean

-- You're trying to find the mean number of items per order on Alibaba, rounded to 1 decimal place using tables which includes information on the count of it...

Foundations Track
aggregation
Alibaba
Alibaba

Foundations Track

Asked at 7 companies
Medium
25 min
April Webinar Share

Alibaba is reviewing april webinar share through a readout. Return the percentage of marketing touches that were webinars in April 2024, rounded to the neare...

Foundations Track
Pro
query basics
aggregation
Alibaba
Alibaba

Foundations Track

Medium
25 min
07. Compressed Mode [Alibaba Interview]

/*Level: MEDIUM You are trying to find the most common (aka the mode) number of items bought per order on Alibaba. However, instead of doing analytics on all...

Foundations Track
Pro
filtering
aggregation
Alibaba
Alibaba

Interview Core Track

Asked at 4 companies
Hard
35 min
Rolling Three-day Earnings

At Alibaba, analysts are preparing a scorecard focused on rolling three-day earnings. Return each user_id, transaction_date, and rolling_3_day_earnings based...

Interview Core Track
query basics
aggregation