0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for information security professionals

SELECT
  q.Id AS [Question ID],
  q.Title AS [Question Title],
  q.Tags AS [Question Tags],
  CASE WHEN a.Id IS NULL THEN 'No' ELSE 'Yes' END AS [Answered],
  COUNT(a.Id) AS [Answer Count],
  q.Score AS [Question Score],
  q.CreationDate AS [Question Creation Date],
  q.ViewCount AS [Question View Count]
FROM
  Posts q
  LEFT JOIN Posts a ON q.Id = a.ParentId AND a.PostTypeId = 2
WHERE
  q.PostTypeId = 1
  AND q.Tags LIKE '%teradata%'
  AND q.CreationDate > '2023-05-19'
GROUP BY
  q.Id,
  q.Title,
  q.Tags,
  a.Id,
  q.Score,
  q.CreationDate,
  q.ViewCount
ORDER BY
  q.CreationDate DESC

fork query

created jun 2 23 anonymous