ให้คำตอบหรือความคิดเห็นอย่างน้อยหนึ่งคำตอบแก่โพสต์ Java ทั้งหมด ไม่จำเป็นต้องใช้ตารางทั้งหมด
Give all Java posts with at least one answer or comment.It is not neccessary to use all the tables.
 PostLinks:  Id [ number]  CreationDate [ time]  PostId [ number]  RelatedPostId [ number]  LinkTypeId [ number] 
SELECT * FROM Comments WHERE PostId IN (SELECT Id FROM Posts WHERE LOWER(Tags) LIKE '%java%' AND NOT LOWER(Tags) LIKE '%javascript%' AND (AnswerCount >= 1 OR CommentCount >= 1))