4 SQL practice questions in our Microsoft 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 · 1 Easy–Medium · 1 Medium · 1 Hard
Independent practice resource. Not affiliated with or endorsed by Microsoft.
These topics come from the questions in this set. Pick one to open the matching problems.
Analyze Teams daily active users (DAU) by feature for the past week. For each day and feature (Chat, Calls, Meetings, Files), calculate the number of distinct users and average session duration in seconds. Return event_date, feature, dau_count, and avg_duration_seconds.
Calculate the 7-day rolling average of daily active users for each Office 365 product. Return only products where daily_active_users is at least 100. Display event_date, product, daily_active_users, and rolling_7d_avg. Order by product and event_date.
Analyze Bing search quality metrics by query category. For each category, calculate: total_queries, avg_click_rank, avg_dwell_time_seconds, click_through_rate, and percentage_no_click. Order by total_queries descending.
4 Microsoft problems, each with its own dataset. Click one and you’re in the workspace, free, right in your browser.
Your dataset
user_id (VARCHAR) · event_date (DATE) · feature (VARCHAR) · action (VARCHAR) · duration_seconds (INTEGER)
user_id (VARCHAR) · region (VARCHAR) · org_size (VARCHAR)
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 Microsoft SQL free188 SQL practice questions. 23 companies. Free access to every problem.