I am new to sql and have been struggling about nan-median, for example, I have a table with three (million) rows, each with ten numbers (or null):
row1: 1,2,3,null,4,5,6,7,8,9
----------
row2: 2,4,null,6,8,2,1,0,9,10
----------
row3: 1,1,1,1,null,7,2,9,9,9
----------
How to get the nan-median of each row?