tajo-core/benchmark/tpch/q11.sql

select
	ps_partkey,
	sum(ps_supplycost * ps_availqty) as value
from
	partsupp,
	supplier,
	nation
where
	ps_suppkey = s_suppkey
	and s_nationkey = n_nationkey
	and n_name = 'GERMANY'
group by
	ps_partkey having
	sum(ps_supplycost * ps_availqty) > (
		select
		sum(ps_supplycost * ps_availqty) * 0.0001
		from
		partsupp,
		supplier,
		nation
		where
		ps_suppkey = s_suppkey
		and s_nationkey = n_nationkey
		and n_name = '[NATION]'
	)
order by
	value desc