SELECT Id, PostTypeId, CreationDate, Score, ViewCount, Ta...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Open Data

Q&A for developers and researchers interested in open data

SELECT 
  Id, PostTypeId, CreationDate, Score, ViewCount, Tags, AnswerCount, FavoriteCount
FROM Posts
WHERE (PostTypeId = 1 OR PostTypeId = 2) AND (year(CreationDate) = 2019)
ORDER BY ViewCount DESC;

Enter Parameters

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