🪲 Variation of TPC-H query fails

[joocer]

select
    sum(l_extendedprice* (1 - l_discount)) as revenue
from
    testdata.tpch_tiny.lineitem,
    testdata.tpch_tiny.part
where
    (
        p_partkey = l_partkey
        and p_brand = 'Brand#32'
        and p_container in ('SM CASE', 'SM BOX', 'SM PACK', 'SM PKG')
        and l_quantity >= 7 and l_quantity <= 7 + 10
        and p_size between 1 and 5
        and l_shipmode in ('AIR', 'AIR REG')
        and l_shipinstruct = 'DELIVER IN PERSON'
    )

appears to fail when the WHERE clause returns zero rows- but that's seen elsewhere so may be not that.