s_acctbal

,s_name

,n_name

,p_partkey

,p_mfgr

,s_address

,s_phone

,s_comment

from

part2

,supplier2

,partsupp2

,nation2

,region2

where

p_partkey = ps_partkey

and s_suppkey = ps_suppkey

and p_size = 15

and p_type like '%BRASS'

and s_nationkey = n_nationkey

and n_regionkey = r_regionkey

and r_name = 'EUROPE'

and ps_supplycost = (

select

min(ps_supplycost)

from

partsupp2

,supplier2

,nation2

,region2

where

p_partkey = ps_partkey

and s_suppkey = ps_suppkey

and s_nationkey = n_nationkey

and n_regionkey = r_regionkey

and r_name = 'EUROPE'

)

order by

s_acctbal desc

,n_name

,s_name

,p_partkey;