Level 7 - ArchitectQuery-Based Questionsm1 indexing strategy
Index-Safe Last Login Dashboard Query
Return users who logged in during last 24h with user_id and max login_at, sorted by latest login desc.
Schema Context
user_logins(user_id, login_at, ip_address)