instruction: Average Posting Stats per Posting Type.
response: SELECT PostTypes.Name AS PostType, AVG(Posts.Score) AS AvgScore FROM Posts, PostTypes WHERE PostTypes.Id = 1 AND Posts.ClosedDate IS NULL AND PostTypes.Id = Posts.PostTypeId GROUP BY PostTypes.Name