Q&A about the site for scientists using computers to solve scientific problems
-- See the CreationDate of the most recent Vote record per VoteTypeId.
WITH summary AS (
ROW_NUMBER() OVER(PARTITION BY VoteTypeId ORDER BY CreationDate DESC) AS r
where r = 1
order by VoteTypeId