Lists all parts supplied by Supplier#000000034.
part refers to p_name; Supplier#000000034 refers to s_name = 'Supplier#000000034'
SELECT T3.p_name FROM partsupp AS T1 INNER JOIN supplier AS T2 ON T1.ps_suppkey = T2.s_suppkey INNER JOIN part AS T3 ON T1.ps_partkey = T3.p_partkey WHERE T2.s_name = 'Supplier#000000034'