ต่อวันตั้งแต่ปี 2562 ไม่จำเป็นต้องใช้ทุกตาราง
s per day since 2019.It is not neccessary to use all the tables.
 CloseAsOffTopicReasonTypes:  Id [ number]  IsUniversal [ boolean]  InputTitle [ text]  MarkdownInputGuidance [ text]  MarkdownPostOwnerGuidance [ text]  MarkdownPrivilegedUserGuidance [ text]  MarkdownConcensusDescription [ text]  CreationDate [ time]  CreationModeratorId [ number]  ApprovalDate [ time]  ApprovalModeratorId [ number]  DeactivationDate [ time]  DeactivationModeratorId [ number] 
SELECT MIN(Posts.CreationDate), COUNT(*) AS "posts per day" FROM Tags INNER JOIN PostTags ON PostTags.TagId = Tags.Id INNER JOIN Posts ON Posts.Id = PostTags.PostId WHERE Tags.TagName = 'rust' AND Posts.CreationDate > '2019-01-01' GROUP BY TIME_TO_STR(Posts.CreationDate, '%d'), TIME_TO_STR(Posts.CreationDate, '%m'), TIME_TO_STR(Posts.CreationDate, '%Y') ORDER BY MIN(Posts.CreationDate)