1create table t1 (a int);
2insert into t1 values (1),(2);
3select max('foo') from t1 group by value(a), extractvalue('bar','qux') order by "v";
4max('foo')
5foo
6drop table t1;
7