HF RL Explorer

Task: SQLite ORDER BY String Containing Numbers Starting with 0

Task: SQLite ORDER BY String Containing Numbers Starting with 0: a task in Terminal-Lego-15k (Harbor dataset). You need to solve a common SQLite sorting problem where a column contains numeric strings with leading zeros. When using a standard ORDER BY clause on such a column, SQLite performs…

The task

You need to solve a common SQLite sorting problem where a column contains numeric strings with leading zeros. When using a standard `ORDER BY` clause on such a column, SQLite performs lexicographic (string) sorting instead of numeric sorting, producing incorrect results like:

Part of PrimeIntellect/Terminal-Lego-15k.