Marshall Wace·Software Engineer·Technical Phone Screen
Jun 2026
SQL question from Marshall Wace for a software engineering role. One question, case-insensitive matching involved, and the kind of thing that looks straightforward until you're actually writing it.
- Given a login_attempts table with user_id, timestamp, status, and country columns, write a query to return all user_ids who have at least one successful login (status = 'SUCCESS', case-insensitive) across two or more distinct countries. Result should be a single column sorted alphabetically.
“The case-insensitive part is what gets you.”