Write SQL query to solve given problem: Calculate the percentage of part supply that costs more than 500.. Keep the solution inside sql tag ```sql [SQL-Query] ```
SELECT CAST(SUM(IIF(ps_supplycost > 500, 1, 0)) AS REAL) * 100 / COUNT(ps_suppkey) FROM partsupp