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.
Apple
Foundations Track
Duplicate Job Posts
Apple wants a scorecard for duplicate job posts. Return the number of employers that posted the same role_name in the same city more than once during April 2...
Apple
Foundations Track
Late Shipment Rate By Carrier
At Apple, analysts are preparing a portfolio scan focused on late shipment rate by carrier. Return the percentage of shipments that arrived late by carrier_n...
Apple
Foundations Track
Signup Confirmation Rate
At Apple, analysts are preparing a trend check focused on signup confirmation rate. Calculate the confirmation rate as the percentage of signups that were co...
Apple
Foundations Track
Creators With Multiple 2024 Posts
Apple wants a reporting cut for creators with multiple 2024 posts. Return each creator_id that posted at least two items in 2024. Sort by creator_id.
Apple
Foundations Track
Bidirectional Transfer Pairs
Apple wants a readout for bidirectional transfer pairs. Count unique transfer relationships regardless of direction. Return relationship_count.
Apple
Interview Core Track
Top Sellers By Gross Sales
At Apple, analysts are preparing a portfolio scan focused on top sellers by gross sales. Return the top 3 sellers by total_gross_sales. Output seller_id and ...
Apple
Foundations Track
Frequent Support Callers
Apple wants a diagnostic pass for frequent support callers. Return the distinct policy_holder_id values for members who made at least 3 calls. Sort by policy...
Apple
Foundations Track
Heavy
At Apple, analysts are preparing a readiness review focused on heavy. Return the distinct policy_holder_id values for members who made at least 3 calls. Sort...
Apple
Foundations Track
Apple Multimedia Active Users
SELECT COUNT(distinct user_id) as distinct_user_count FROM fct_multimedia_usage WHERE usage_date='2024-07-31'
Apple
Foundations Track
April Webinar Share
Apple wants a operations review for april webinar share. Return the percentage of marketing touches that were webinars in April 2024, rounded to the nearest ...
Apple
Foundations Track
19 Apple Pay Volume
SELECT merchant_id, SUM(CASE WHEN LOWER(payment_method) = 'apple pay' THEN transaction_amount ELSE 0 END) AS volume FROM transactions GROUP BY 1 ORDER BY 2 D...
Apple
Interview Core Track
9. Follow-Up AirPod Percentage
The Apple Customer Retention Data Science team needs your help to investigate buying patterns related to AirPods and iPhones. Write a SQL query to determine ...