CREATE TABLE T1( JSON, c2 ); CREATE TABLE T2( NUMERIC); CREATE TABLE T3( REAL, c2 ); SELECT (SELECT ROW_NUMBER() OVER (ORDER BY c.c2) ), DENSE_RANK() OVER (ORDER BY a.c2) FROM T1 a JOIN T2 ON a. c2 JOIN T3 c