(count) Questions posted by users within specific creation date

1

Please login or register to vote for this query.

(click on this box to dismiss)

History of Science and Math

Q&A for people interested in the history and origins of science and mathematics

SELECT convert(date, p.CreationDate) AS date, p.PostTypeId AS type, COUNT(p.Id) AS number   
FROM Posts p
INNER JOIN Users u ON u.Id = p.OwnerUserId
WHERE UPPER(u.Location) LIKE '%, TX%'
AND u.Reputation >= 10000
AND convert(date, p.CreationDate) >= convert(date, ##Start:string##)
AND convert(date, p.CreationDate) <= convert(date, ##End:string##)
AND (p.PostTypeId = 1 OR p.PostTypeId = 2)
GROUP BY convert(date, p.CreationDate), p.PostTypeId
ORDER BY convert(date, p.CreationDate)

Enter Parameters

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