HF RL Explorer

Task: Calculate the Median of Values in SQLite

Task: Calculate the Median of Values in SQLite: a task in Terminal-Lego-15k (Harbor dataset). Write a SQLite query (or set of queries) that correctly calculates the median of a numeric column. SQLite does not have a built-in MEDIAN() aggregate function, so you must implement the logic using…

The task

Write a SQLite query (or set of queries) that correctly calculates the **median** of a numeric column. SQLite does not have a built-in `MEDIAN()` aggregate function, so you must implement the logic using available SQL features.

Part of PrimeIntellect/Terminal-Lego-15k.