Point72·Software Engineer·Online Assessment (OA)
- Given a cryptocurrency exchange transaction table, write a PostgreSQL query to detect potential fraud by finding sender-recipient pairs with 2 or more transactions, then aggregate results per sender showing: the time period of activity, and a formatted string of transaction amounts sorted descending (top 3 shown explicitly, the rest collapsed with a count suffix). Order final output by total amount descending.
“This one ate up way more time than it should have.”