Q&A for SharePoint enthusiasts
Select TOP 50 DISPLAYNAME, TITLE, OwnerDisplayName FROM USERS AS U LEFT JOIN POSTS AS P ON P.OwnerUserID = U.AccountId