Google-style Company ChallengeBeginnerVerified answerSQLite live

Recent Signups

Which users signed up on or after February 1, 2024?

  • Filtering
  • Sorting

Challenge brief

Understand the request

Onboarding Team is reviewing the February 2024 new user cohort for a welcome-email campaign.

Return user_id, country, device_type, signup_date in the declared deterministic order.

Return

  • user_id
  • country
  • device_type
  • signup_date

Constraints

  • Include signups on or after 2024-02-01
  • Order by user ID

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

Signup date is a user attribute.

Hint 2

Keep the boundary date in the qualifying range.

Hint 3

Project explicit user columns and order by identifier.

Verified SQL answer

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

Reveal solution and explanation
SELECT user_id, country, device_type, signup_date FROM users WHERE signup_date >= '2024-02-01' ORDER BY user_id

Why this works

ISO date strings (YYYY-MM-DD) compare correctly as text in SQLite. signup_date >= '2024-02-01' returns 4 users who signed up in February — users 20, 21, 22, 23.

Success check

Returns the complete deterministic result for recent signups

Expected result

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

user_idcountrydevice_typesignup_date
20Canadamobile2024-02-01
21Spaindesktop2024-02-05
22Italymobile2024-02-08
23Mexicotablet2024-02-10
24USAmobile2024-02-12

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.