Inside the Databricks set
SQL topics you can practice.
These topics come from the questions in this set. Pick one to open the matching problems.
Easy · 5 min
Analyze March 2026 transactions by subscription tier. For active users, calculate active user count, average transaction amount, total revenue, and transaction count per tier. Return subscription_tier, active_user_count, avg_transaction_amount, total_revenue, transaction_count. Order by total_revenue descending.
Tables: users, transactions
Medium · 10 min
Calculate the 7-day rolling average of daily active users per workspace for March 2026. Return workspace_id, region, session_date, daily_active_users, rolling_7d_avg. Order by workspace_id, session_date.
Tables: workspace_sessions, workspaces
Hard · 15 min
For March 2026, identify workspaces with total cluster costs > $500 and failure rates > 5%. Return workspace_id, customer_id, total_cost, run_count, failure_rate_pct, avg_compute_hours. Order by failure_rate_pct descending.
Tables: cluster_runs, clusters, workspaces