OTP category with the most code entries
Bank Otkritie is rolling out 2FA in the mobile app and wants to know which scenarios trigger OTP entries most often — to optimise UX and size the SMS gateway. Input: a log of attempts with status and context (IP, payload).
Find the category with the most code-entry attempts — count every attempt regardless of status.
Expected output sample
This is what a correct answer looks like — its row count is its own, it doesn't have to match the schema tables.
| category | codes_count |
|---|---|
| payment | 6 |
Bank Otkritie
Sign in to see submission history
Sign inSign in to use AI Mentor
Sign inFocus radio
Paused · SomaFM · Fluid