SQLite Forum

Get column rank from values in selected row
Login
What is preventing you from loading the non-normalized data into normalized tables? That would be the classic job of the "input" phase: convert data to the form best suited to the actual processing.

What if some day the input format is changed to a different number of precentiles or the borders change? You would have to rewrite all of the queries, as opposed to adjusting only the input conversion.