Alibaba practice guide
Stay inside one business context for a few reps in a row while still working from the same live bank used across practice, tracks, and reviews.
Alibaba
Explore 10 Alibaba-tagged SQL scenarios focused on query basics, aggregation, filtering.
Context, not signal
Company labels help frame practice in a familiar business context. They are directional study aids, not official interview guidance from the companies listed.
Sign in to track progress while you browse this guide.
Questions
10
Estimated prep time
190 min
Progress tracking
Sign in to track progress
Concept focus
The most common patterns in the current Alibaba-tagged set.
Query basics
7
Aggregation
5
Filtering
2
Mix at a glance
Use the difficulty and path mix to decide whether you want fundamentals, breadth, or stretch reps.
Suggested rhythm
Start with the easiest scenario in the set, then move upward while tracking accuracy and retry speed. This keeps the context stable while the difficulty rises.
Suggested next scenarios
The next best reps from this company-tagged set based on what you have not solved yet.
Second-highest Salary
Practice query basics through a Alibaba-tagged business scenario.
Creators With Multiple 2024 Posts
Practice query basics through a Alibaba-tagged business scenario.
2024 App Click Volume
Practice query basics through a Alibaba-tagged business scenario.
Question list
The current Alibaba-tagged list with learning objectives and your latest status.
Second-highest Salary
Alibaba wants a readout for second-highest salary. Return the second-highest salary amount in the table as second_highest_salary.
Practice query basics through a Alibaba-tagged business scenario.
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...
Practice query basics through a Alibaba-tagged business scenario.
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.
Practice query basics through a Alibaba-tagged business scenario.
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...
Practice query basics through a Alibaba-tagged business scenario.
Creators With Multiple 2024 Posts
At Alibaba, analysts are preparing a monthly brief focused on creators with multiple 2024 posts. Return each creator_id that posted at least two items in 202...
Practice query basics through a Alibaba-tagged business scenario.
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 ...
Practice filtering through a Alibaba-tagged business scenario.
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...
Practice aggregation through a Alibaba-tagged business scenario.
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...
Practice query basics through a Alibaba-tagged business scenario.
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...
Practice filtering through a Alibaba-tagged business scenario.
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...
Practice query basics through a Alibaba-tagged business scenario.