Practice Affirm Coding Question | Real Coding Interviews | Hack2hire

NewML System Design & SQL tracks just landedSee what's new

Question Bank Pricing Blog Forum

Quick Summary

Filter transaction logs to retain only completed records within a 24-hour window.
Group qualifying transactions by merchant ID and their hour difference from the current time.
Sum the amounts for each merchant-hour pair and return the resulting nested aggregation.

What This Tests

Nested hash map construction and traversal
Multi-condition data filtering
String-to-number conversion and arithmetic accumulation
Efficient single-pass data aggregation

Common Patterns

Hashing

Stdout

-