In-Memory Table from CSV: Parse, Select Columns, WHERE Filters, ORDER BY

Also reported as In-Memory SQL · CSV Parsing and Querying · In-Memory DB

CodingMicrosoftLast reported May 2026Medium Frequency
Reported
4× across candidate reports
First seen
March 2026
Last reported
May 2026
Reported outcome
fail

Problem Overview

Microsoft coding question, reconstructed from 4 candidate reports (March 2026 to May 2026). Candidates reported 4 follow-ups. The write-up includes a Python solution that passes 14 test cases.

  • 4 candidate-reported follow-ups — the probes candidates report being asked, with the trigger for each
  • The full problem statement — full requirements, constraints, and edge cases
  • Approach and trade-offs — what passing candidates did, and the mistakes that sink people
Unlock the full Microsoft catalog
Full problem statements, candidate-reported follow-ups, and walkthroughs — for every Microsoft question.
Unlock with Pro
Already a member? Sign in
Verified Source
Every question is reconstructed from multiple independent candidate reports. Follow-ups candidates reported, not invented ones.
Codex Fact-Checked
Technical claims, formulas, and scale numbers are reviewed against primary sources.
Interviewer Follow-ups
The follow-ups candidates reported, with the trigger that prompts each one — plus the mistakes that sink people.
Is this helpful?