yql/essentials/tests/sql/suites/pg/YQL_20895_projection_depth_3.sql


1
2
3
4
5
6
7

--!syntax_pg

SELECT (Count(*) / (
    SELECT (Count(*) / (SELECT Count(*) FROM (VALUES (1.0)) AS t(x)))
    FROM (VALUES ('1')) AS t(x) GROUP BY x
))
FROM (VALUES (1)) AS t(x) GROUP BY x;