1

Please login or register to vote for this query.

(click on this box to dismiss)

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

SELECT COUNT(p.Id), convert(date, p.CreationDate), p.PostTypeId 
FROM Posts p
INNER JOIN Users u ON u.Id = p.OwnerUserId
WHERE UPPER(u.Location) LIKE '%CHINA%' 
AND convert(date, p.CreationDate) >= convert(date, ##Start:string##)
AND convert(date, p.CreationDate) <= convert(date, ##End:string##)
GROUP BY convert(date, p.CreationDate), p.PostTypeId
ORDER BY convert(date, p.CreationDate)

view current version

edited jul 2 20

created jun 24 20 Alice CHING