instruction: What percentage of all posts are answers (for top users - including deleted users).
response: SELECT p.OwnerUserId AS "user_link", p.OwnerDisplayName, ROUND((SUM(CASE WHEN p.PostTypeId = 2 THEN 1 ELSE 0 END)) * 100.0 / (COUNT(p.Id)), 2) AS "percentage_answers", SUM(p.Score) AS "total_score", COUNT(p.Id) AS "total_posts", SUM(CASE WHEN p.PostTypeId = 1 THEN 1 ELSE 0 END) AS "total_questions", SUM(CASE WHEN p.PostTypeId = 2 THEN 1 ELSE 0 END) AS "total_answers", SUM(CASE WHEN p.PostTypeId = 1 THEN p.Score ELSE 0 END) AS "score_questions", SUM(CASE WHEN p.PostTypeId = 1 THEN p.Score ELSE 0 END) AS "score_answers" FROM Posts AS p GROUP BY p.OwnerUserId, p.OwnerDisplayName ORDER BY SUM(p.Score) DESC LIMIT 500