Find and list the part key of the parts which has an above-average retail price.
part key of the parts which has an above-average retail price refer to p_partkey where p_retailprice > AVG(p_retailprice);
SELECT p_partkey FROM part WHERE p_retailprice > ( SELECT AVG(p_retailprice) FROM part )