Snowflake phone-screen question, reconstructed from 1 candidate report (May 2025). Tests: tries and prefix search; hash-map counting, grouping and joins. Candidates reported 3 follow-ups. The write-up includes a Python solution that passes 7 test cases.