ydb/yt/yql/tests/sql/suites/optimizers/pushdown_nonsep_over_aggregate.sql

USE plato;

pragma config.flags("OptimizerFlags", "PushdownComplexFiltersOverAggregate");

SELECT * FROM (
    SELECT
        key as key,
        min(value) as mv
    FROM Input
    GROUP BY key
)
WHERE AssumeNonStrict(200 > 100) and (2000 > 1000) and key != "911" and (key < "150" and mv != "ddd" or key > "200");