medium · ~12 min
Security wants an active-user directory combining each user's profile with their most recent login timestamp and IP address.
Write a query that builds this directory:
logins
login_time
last_login_time
ip_address
user_id
username
email
Input contract: user_id is unique and non-null in users; login_id is unique and non-null in logins; all columns are non-null. Within each user_id, login_time values are distinct (no ties for latest login), and a user may have zero, one, or many rows in logins.
users
login_id