instruction: Percentage of votes - depending on day after posting (only questions).
response: SELECT DATEDIFF(day, p.CreationDate, CreationDate) AS Days, COUNT(v.Id) AS Count, COUNT(v.Id) * 100.0 / SUM(COUNT(v.Id)) OVER () AS Percentage FROM Votes AS v INNER JOIN Posts AS p ON v.PostId = p.Id WHERE p.PostTypeId = 1 GROUP BY DATEDIFF(day, p.CreationDate, CreationDate) ORDER BY DATEDIFF(day, p.CreationDate, CreationDate)