github.com/matrixorigin/matrixone@v1.2.0/pkg/sql/plan/tpch/q14.sql (about)

     1  select
     2  	100.00 * sum(case
     3  		when p_type like 'PROMO%'
     4  			then l_extendedprice * (1 - l_discount)
     5  		else 0
     6  	end) / sum(l_extendedprice * (1 - l_discount)) as promo_revenue
     7  from
     8  	lineitem,
     9  	part
    10  where
    11  	l_partkey = p_partkey
    12  	and l_shipdate >= date '1996-04-01'
    13  	and l_shipdate < date '1996-04-01' + interval '1' month;