Q&A about the site for members of the workforce navigating the professional setting
SELECT TOP 20 Id AS [Post ID], Title, CreationDate AS [Date Created], Score, PostTypeId, CASE WHEN PostTypeId = 1 THEN 'Question' WHEN PostTypeId = 2 THEN 'Answer' ELSE 'Other' END AS [Post Type], OwnerUserId AS [User ID] FROM Posts ORDER BY CreationDate DESC