instruction: Average question score by account age (up to 1 year).
response: SELECT DATEDIFF(DAY, u.CreationDate, CreationDate) AS "Account age (days)", AVG(CAST(p.Score AS FLOAT)) AS "Average score" FROM Posts AS p INNER JOIN Users AS u ON p.OwnerUserId = u.Id WHERE p.PostTypeId = 1 AND DATEDIFF(DAY, u.CreationDate, CreationDate) BETWEEN 0 AND 365 GROUP BY DATEDIFF(DAY, u.CreationDate, CreationDate) ORDER BY DATEDIFF(DAY, u.CreationDate, CreationDate)