Google-style Company ChallengeBeginnerVerified answerSQLite live

Total Users Count

How many users are registered on the product platform?

  • Aggregation

Challenge brief

Understand the request

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

Return total_users in the declared deterministic order.

Return

  • total_users

Constraints

  • Return one row with the total registered-user count

Data you will use

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

users

  • user_idINTEGER
  • countryVARCHAR(50)
  • device_typeVARCHAR(20)
  • signup_dateDATE

Hints, when you need them

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

Hint 1

The answer comes from the registered-user table.

Hint 2

Count rows at the table grain.

Hint 3

Return the count under the requested alias.

Verified SQL answer

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

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

Why this works

COUNT(*) counts every row in the table. No WHERE or GROUP BY needed — you want the grand total. There are 23 users in the dataset.

Success check

Returns the complete deterministic result for total users count

Expected result

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

total_users
24

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.