1

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for expert genealogists and people interested in genealogy or family history

select 'https://stackoverflow.com/questions/' +
CAST(p.Id AS VARCHAR) AS 'Post Link',
p.CreationDate,p.LastActivityDate,p.AnswerCount,
p.ViewCount,p.Title,p.Tags,p.AcceptedAnswerId,p.Body,p.ClosedDate,p.CommentCount
from posts p
where p.CreationDate >= '2021-06-01'
and p.CreationDate < '2022-05-20'
--and p.Tags like '%<##tag?amazon-sagemaker##>%'
and p.PostTypeId = 2 -- questions only
and p.OwnerUserId  = 1821979
--and p.AcceptedAnswerId IS NULL
--and p.AnswerCount < 1 -- COMMENT IN for unanswered, OUT for all Qs
order by p.AnswerCount asc, p.ViewCount desc;

fork query

edited apr 1 22

created aug 4 21 rtcode