15 SQL practice questions in our Apple collection, part of our 188-question bank across 23 companies. Write SQL against practice datasets and get checked in your browser. Free, no card or trial.
No account needed to start. Draft SQL stays in this browser; create an account to sync solved history.
1 Easy · 10 Medium · 4 Hard
Independent practice resource. Not affiliated with or endorsed by Apple.
These topics come from the questions in this set. Pick one to open the matching problems.
Rank apps by downloads within each category for March 15, 2026. Return category, rank, app_id, app_name, and downloads_today. Use RANK() so that ties share the same rank. Only show the top 5 apps per category.
Analyze AirPods purchase patterns by region for Q1 2026 (Jan-Mar). For each region, calculate: total_units, total_revenue, avg_price, and the model mix as pct_airpods_pro, pct_airpods_max, and pct_airpods_3.
Create a monthly cohort analysis for Apple Music. For users who signed up in January 2026, calculate total listening hours in each month: month 0 (signup month), month 1, and month 2. Return signup_month, user_count, m0_hours, m1_hours, m2_hours.
15 Apple problems, each with its own dataset. Click one and you’re in the workspace, free, right in your browser.
Your dataset
purchase_id (BIGINT) · customer_id (BIGINT) · model (VARCHAR) · region (VARCHAR) · purchase_date (DATE) · price_usd (DECIMAL)
Start free, no account needed. When you create one, everything you’ve solved comes with you — solved marks, streaks, and concept ratings on your dashboard.
Practice Apple SQL free188 SQL practice questions. 23 companies. Free access to every problem.