คำตอบของฉันสำหรับแท็กที่กำหนด ไม่จำเป็นต้องใช้ตารางทั้งหมด
My answers for a given tag.It is not neccessary to use all the tables.
 ReviewRejectionReasons:  Id [ number]  Name [ text]  Description [ text]  PostTypeId [ number] 
SELECT * FROM (SELECT Posts.Id FROM Tags JOIN PostTags ON PostTags.TagId = Tags.Id JOIN Posts ON Posts.Id = PostTags.PostId WHERE TagName = '##tagName##' AND Posts.PostTypeId = 1) AS questions JOIN Posts ON Posts.ParentId = questions.Id WHERE Posts.PostTypeId = 2 AND Posts.OwnerUserId = '##UserId##' AND Posts.CreationDate > '2019/9/01'