resources/tpch/q2.sql

0001 -- using default substitutions
0002
0003 select
0004         s_acctbal,
0005         s_name,
0006         n_name,
0007         p_partkey,
0008         p_mfgr,
0009         s_address,
0010         s_phone,
0011         s_comment
0012 from
0013         part,
0014         supplier,
0015         partsupp,
0016         nation,
0017         region
0018 where
0019         p_partkey = ps_partkey
0020         and s_suppkey = ps_suppkey
0021         and p_size = 15
0022         and p_type like '%BRASS'
0023         and s_nationkey = n_nationkey
0024         and n_regionkey = r_regionkey
0025         and r_name = 'EUROPE'
0026         and ps_supplycost = (
0027                 select
0028                         min(ps_supplycost)
0029                 from
0030                         partsupp,
0031                         supplier,
0032                         nation,
0033                         region
0034                 where
0035                         p_partkey = ps_partkey
0036                         and s_suppkey = ps_suppkey
0037                         and s_nationkey = n_nationkey
0038                         and n_regionkey = r_regionkey
0039                         and r_name = 'EUROPE'
0040         )
0041 order by
0042         s_acctbal desc,
0043         n_name,
0044         s_name,
0045         p_partkey
0046 limit 100