The Category of Each Member in the Store

Given members and their purchase records (and possibly a category precedence or timestamp), determine each member's store category by aggregating their transactions and applying selection/tie-breaking rules (e.g., most frequent, highest-precedence, or most recent category). The task focuses on joins, grouping/aggregation and careful tie-break logic to produce one category per member.