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)