Flag Accounts With Multi-Country Logins | Dataford Interview Questions
Flag Accounts With Multi-Country Logins
HardWindow FunctionsDate FunctionsGroup By
Problem
Given a table of login attempts, write a SQL query to flag accounts that have attempted to log in from more than three different countries in a 24-hour period.
Problem
Given a table of login attempts, write a SQL query to flag accounts that have attempted to log in from more than three different countries in a 24-hour period.
Your answer
Try one AI text evaluation on us
Get structured feedback, scored against a 4-axis rubric. Premium unlocks unlimited.
