github.com/matrixorigin/matrixone@v0.7.0/pkg/sql/plan/tpch/q17.sql (about)

     1  select
     2  	sum(l_extendedprice) / 7.0 as avg_yearly
     3  from
     4  	lineitem,
     5  	part
     6  where
     7  	p_partkey = l_partkey
     8  	and p_brand = 'Brand#54'
     9  	and p_container = 'LG BAG'
    10  	and l_quantity < (
    11  		select
    12  			0.2 * avg(l_quantity)
    13  		from
    14  			lineitem
    15  		where
    16  			l_partkey = p_partkey
    17  	);