yql/essentials/tests/sql/suites/optimizers/yql-5833-table_content.sql


1
2
3
4
5
6
7
8
9
10
11
12
13

/* postgres can not */
use plato;

$max_key = (
select
max(key)
from Input
);

select
cast(count(*) as String) || ' (' || cast($max_key as String) ||'/24)'
from Input
where key = $max_key;