Microsoft-style Company ChallengeBeginnerVerified answerSQLite live

Total Users

How many users are registered on the Microsoft platform in total?

  • Aggregation

Challenge brief

Understand the request

Growth Analytics needs a single headline number — total registered users — for the weekly executive KPI dashboard.

Return the total count of registered users as total_users.

Return

  • total_users

Constraints

  • Return one row containing the complete registered-user count

Data you will use

Review the relevant tables before deciding how to join, filter, or aggregate them.

users

  • user_idINTEGER
  • countryTEXT
  • signup_dateDATE

Hints, when you need them

Open one clue at a time so you still do the reasoning.

Hint 1

All user records are in the users table. You need a single total count — no GROUP BY, no JOIN, no filter.

Hint 2

SELECT COUNT(*) AS total_users FROM users.

Hint 3

Build question 1 from the required result grain: choose the driving table, add only the joins and filters needed for that grain, then apply aggregation and deterministic ordering.

Verified SQL answer

Attempt the problem first, then compare structure and reasoning—not just syntax.

Reveal solution and explanation
SELECT COUNT(user_id) AS total_users FROM users;

Why this works

COUNT(*) counts every row in the users table. No WHERE or GROUP BY needed — the result is 12, one row per registered user.

Success check

1 row — total_users: 12

Expected result

Use this output to verify values, aliases, ordering, and row count.

total_users
13

Learn the concepts behind this answer

Strengthen your understanding with these targeted learning topics:

Continue practicing

Explore related company challenges

SQL Interview Practice →

Return to the complete interview preparation experience.