ที่ปรึกษาการลงทะเบียนโพสต์ - Setembro 2016 ไม่จำเป็นต้องใช้ตารางทั้งหมด
Consulta Registros de Posts - Setembro 2016.It is not neccessary to use all the tables.
 CloseReasonTypes:  Id [ number]  Name [ text]  Description [ text] 
SELECT Id, PostTypeId, Score, Title, Body, Tags, ViewCount, AnswerCount, CommentCount, FavoriteCount, CreationDate, DeletionDate, ClosedDate FROM Posts WHERE CreationDate BETWEEN '2016-09-30' AND '2016-10-20' AND Tags LIKE '%java%' AND (Tags LIKE '%maven%' OR Tags LIKE '%ant%' OR Tags LIKE '%jenkins%') AND ViewCount > 50 AND AnswerCount > 0