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


1
2
3
4
5
6
7
8

--!syntax_pg

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