Q&A for cartographers, geographers and GIS professionals
SELECT TOP 1 question.Id as 'Question ID', question.OwnerUserId as 'Owner User ID', ou.Location as 'Owner Location', aa.Id as 'AcceptedAnswerID', aa.OwnerUserId as 'User Who Answered', uaa.Location as 'User Who Answered Location', question.Tags as 'Tags', question.Body as 'Body' FROM Posts question INNER JOIN Posts aa ON question.AcceptedAnswerId = aa.Id INNER JOIN Users ou ON question.OwnerUserId = ou.Id INNER JOIN Users uaa ON aa.OwnerUserId = uaa.Id WHERE question.PostTypeId = 1 AND question.score >= 0 AND question.AnswerCount > 0 AND YEAR(question.CreationDate) = '2019'