Q&A for users of Linux, FreeBSD and other Un*x-like operating systems
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