Find users with multi-country successful logins
Company: Marshall Wace
Role: Software Engineer
Category: Data Manipulation (SQL/Python)
Difficulty: Medium
Interview Round: Onsite
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.
Quick Answer: 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.