instruction: Top 500 Posts by Score.
response: SELECT Posts.Title AS "post_title", COUNT(Posts.Score) AS Score, CAST(AVG(CAST(Score AS FLOAT)) AS FLOAT(6, 2)) AS "average_answer_score" FROM Posts GROUP BY Posts.Title ORDER BY Posts.Title DESC LIMIT 500