Write SQL query to solve given problem: Find and list the part key of the parts which has an above-average retail price.. Keep the solution inside sql tag ```sql [SQL-Query] ```
SELECT p_partkey FROM part WHERE p_retailprice > ( SELECT AVG(p_retailprice) FROM part )