R คำถามที่ไม่มีคำตอบและไม่มีความคิดเห็น ไม่จำเป็นต้องใช้ตารางทั้งหมด
R Questions with no answers and no comments.It is not neccessary to use all the tables.
 CloseReasonTypes:  Id [ number]  Name [ text]  Description [ text] 
SELECT p.Id AS "post_link", p.Score, CreationDate FROM Posts AS p INNER JOIN PostTags AS pt ON p.Id = pt.PostId INNER JOIN Tags AS t ON pt.TagId = t.Id WHERE p.PostTypeId = 1 AND p.Score >= 2 AND p.ClosedDate IS NULL AND COALESCE(p.AnswerCount, 0) = 0 AND COALESCE(p.CommentCount, 0) = 0 AND t.TagName = 'r' AND DeletionDate IS NULL ORDER BY CreationDate DESC LIMIT 30