statement ok
explain (o) select * from (
    select x, y from (
    select x, y, rank() over (partition by x order by y) as rank
    from __mock_t9
    ) where rank <= 3
) order by y limit 10;

query nosort +timing:x10:.q1
select * from (
    select x, y from (
    select x, y, rank() over (partition by x order by y) as rank
    from __mock_t9
    ) where rank <= 3
) order by y limit 10;
----
999 5000000 
999 5000000 
999 5000002 
999 5000002 
999 5000002 
999 5000002 
998 5005001 
998 5005001 
998 5005002 
998 5005002