Find users with multi-country successful logins
Overview
This question evaluates proficiency in relational data manipulation, text normalization, aggregation, deduplication, and sorting within the Data Manipulation (SQL/Python) domain, focusing on practical query-writing and data-processing skills.
Marshall Wace
Aug 13, 2025, 12:00 AM
Software Engineer
Onsite
Data Manipulation (SQL/Python)
0
0
Given a table login_attempts with columns: user_id (TEXT), timestamp (TIMESTAMP), status (TEXT), and country (TEXT), write an SQL query to return the user_id of all users who have at least one 'SUCcEss' login from two or more different countries. The result should be a single column named user_id, sorted alphabetically.