Popularity of cheese related posts by year

1

Please login or register to vote for this query.

(click on this box to dismiss)

Software Engineering

Q&A for professionals, academics, and students working within the systems development life cycle

SELECT DATEPART(YEAR, CreationDate) AS Year, COUNT(*) AS Posts
FROM Posts
WHERE LOWER(Body) LIKE '%cheese%'
GROUP BY DATEPART(YEAR, CreationDate)
ORDER BY DATEPART(YEAR, CreationDate)

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results