SELECT COUNT(*) as TotalQuestions, YEAR(CreationDate) as ...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Science Fiction and Fantasy

Q&A for science fiction and fantasy enthusiasts

SELECT 
  COUNT(*) as TotalQuestions,
  YEAR(CreationDate) as Year
FROM 
  Posts
WHERE 
  Tags LIKE '%<swift>%' AND
  PostTypeId = 1 AND
  YEAR(CreationDate) = 2023  -- change this year to the one you're interested in
GROUP BY 
  YEAR(CreationDate)

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results