India Signups
Return user_id and signup_date for users in India (country = 'IN'), ordered by user_id.
- Filtering
- Sorting
Challenge brief
Understand the request
Regional Growth — APAC The APAC growth team is building a regional report and needs a clean list of Indian users with their signup dates.
Show all users who signed up from India.
Return
- user_id
- signup_date
Constraints
- Return only users whose country is 'IN'
- Order by user ID
Data you will use
Review the relevant tables before deciding how to join, filter, or aggregate them.
users
user_idINTEGERcountryVARCHAR(50)signup_dateDATE
Hints, when you need them
Open one clue at a time so you still do the reasoning.
Hint 1
Country and signup date are user attributes.
Hint 2
Apply the regional code as a row filter.
Hint 3
Project the identifier and date in stable order.
Verified SQL answer
Attempt the problem first, then compare structure and reasoning—not just syntax.
Reveal solution and explanation
SELECT user_id, signup_date FROM users WHERE country = 'IN' ORDER BY user_idWhy this works
WHERE country = 'IN' filters to Indian users. signup_date is included so the regional team can see when each user joined.
Success check
Returns the complete deterministic result for india signups
Expected result
Use this output to verify values, aliases, ordering, and row count.
| user_id | signup_date |
|---|---|
| 2 | 2023-02-15 |
| 6 | 2023-06-01 |
Learn the concepts behind this answer
Strengthen your understanding with these targeted learning topics:
Continue practicing
Explore related company challenges
Google
Independent Google-style search, advertising, user-engagement, and video-product SQL practice.
Meta
Independent Meta-style social-product, engagement, content, community, messaging, and advertising SQL practice.
Airbnb
Independent Airbnb-style marketplace, booking, listing, payment, review, and guest analytics SQL practice.
Return to the complete interview preparation experience.