instruction: View and votes per question.
response: SELECT v.PostId AS "post_link", p.CreationDate AS "Date", p.ViewCount AS "Views", COUNT(v.PostId) AS "Vote count" FROM Votes AS v INNER JOIN Posts AS p ON p.Id = v.PostId WHERE PostTypeId = 1 AND v.VoteTypeId IN (2, 3) AND p.CreationDate >= '2010-01-01' GROUP BY v.PostId, p.ViewCount, p.CreationDate ORDER BY Date DESC