Find users with multi-country successful logins

Q: Find users with multi-country successful logins

This is a Data Manipulation (SQL/Python) interview question from Marshall Wace for Software Engineer roles. View the full question and solution on PracHub.

Q: How do I approach Data Manipulation (SQL/Python) interview questions?

Data Manipulation (SQL/Python) questions require understanding of core concepts and practice. PracHub provides solutions with explanations to help you master data manipulation (sql/python) interviews.

Question

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.

Find users with multi-country successful logins

Comments (0)