List in list arranging

IF X , A , B and C are lists
X = [ A ,B, C]
A = [ R ,T ,9]
B = [ Q, X, 7]
C = [ S ,D ,15]
How to arrange X elements due to numbers in A,B and C
Note : X after arranging suppose to be X = [ C, A,B]
:smiley:

put your data into the sqlite database like this

Col1,Col2,Col3,Col4
A,   R ,  T,   9
B,   Q,   X,   7
C,   S,  D ,  15

and use a select statement like this

SELECT Col1 FROM myTable ORDER BY Col4 DESC

Taifun

2 Likes

Ok , I will try
Thank you @Taifun