0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for software developers, mathematicians and others interested in cryptography

-- Fetch questions and top answers related to data science in healthcare from 2021 to 2024, including tags
SELECT TOP 50 -- Fetch the top 50 results
    q.Id AS QuestionId,
    q.Title AS QuestionTitle,
    q.Body AS QuestionBody,
    q.Score AS QuestionScore,
    a.Id AS AnswerId,
    a.Body AS AnswerBody,
    a.Score AS AnswerScore,
    q.CreationDate AS QuestionDate,
    a.CreationDate AS AnswerDate,
    q.Tags AS QuestionTags -- Add a column for the tags of the question
FROM Posts AS q
LEFT JOIN Posts AS a ON q.Id = a.ParentId
WHERE q.PostTypeId = 1 -- Questions
  AND a.PostTypeId = 2 -- Answers
  AND (
      q.Tags LIKE '%data-science%' 
      OR q.Tags LIKE '%machine-learning%' 
      OR q.Tags LIKE '%artificial-intelligence%' 
      OR q.Tags LIKE '%healthcare%' 
      OR q.Tags LIKE '%big-data%' 
      OR q.Tags LIKE '%deep-learning%'
      OR q.Tags LIKE '%statistics%' 
      OR q.Tags LIKE '%medical-imaging%' 
  )
  AND q.CreationDate >= '2021-01-01' -- Start of 2021
  AND q.CreationDate < '2025-01-01' -- End of 2024
  AND a.Score = (
      SELECT MAX(a2.Score)
      FROM Posts AS a2
      WHERE a2.ParentId = q.Id AND a2.PostTypeId = 2
  )
ORDER BY q.Score DESC, a.Score DESC;

fork query

edited dec 13

created dec 13 anonymous