Perguntas e respostas para programadores profissionais e entusiastas
SELECT TOP 30 CONVERT(DATETIME, CONCAT(YEAR(p.CreationDate), '-', MONTH(p.CreationDate), '-01'), 20) AS Mes, datediff(day,p.CreationDate,v.CreationDate), * FROM Posts as p JOIN (Select TOP 1 CreationDate,PostId FROM Votes ORDER BY CreationDate) v ON v.PostId=p.Id