Q&A about the site for expert genealogists and people interested in genealogy or family history
WITH QUESTIONS AS( SELECT Id,Body FROM Posts WHERE PostTypeId=1 AND AnswerCount >= 10 AND CONVERT(VARCHAR(250), Tags) = '<c>' ), ANSWERs AS( SELECT a.Body from Posts as a, Questions as q WHERE a.PostTypeId=2 AND a.ParentID=q.Id ), TOTAL AS( SELECT q.* FROM QUESTIONS AS q,ANSWERS as a ) SELECT * FROM TOTAL