What is the name of the product with the highest retail price?
name of the product refers to p_name; the highest retail price refers to p_retailprice
SELECT p_name FROM part WHERE p_retailprice = ( SELECT MAX(p_retailprice) FROM part )