instruction: Tag new question activity.
response: SELECT RIGHT(LEFT(CreationDate, 11), 4) AS Year, COUNT(Id) AS PostCount, COUNT(Id) / 365 AS AveragePostsPerDay, SUM(ViewCount) AS Views, SUM(ViewCount) / 365 AS ViewsPerDay FROM Posts WHERE Tags LIKE '%JavaScript%' GROUP BY RIGHT(LEFT(CreationDate, 11), 4) ORDER BY RIGHT(LEFT(CreationDate, 11), 4) DESC