โพสต์จะดีขึ้น/เป็นที่นิยมมากขึ้นหรือไม่ ถ้ามีแท็กในหัวเรื่อง? ไม่จำเป็นต้องใช้ตารางทั้งหมด
Are posts better/more popular if they have a tag in their title?.It is not neccessary to use all the tables.
 PostTypes:  Id [ number]  Name [ text] 
SELECT COUNT(*) AS Number, AVG(p.ViewCount) AS Views, ROUND(AVG(CAST(p.Score AS FLOAT)), 3) AS Score, ROUND(AVG(CAST(p.AnswerCount AS FLOAT)), 3) AS AnswerCount, CAST(AVG(CAST(p.CreationDate AS FLOAT)) AS DATETIME) AS AvgDate, CASE WHEN LOWER(p.Title) LIKE '%##TagName##%' THEN 'yes' ELSE 'no' END AS TagInTitle FROM Posts AS p INNER JOIN PostTags AS pt ON p.Id = pt.PostId INNER JOIN Tags AS t ON t.Id = pt.TagId WHERE p.PostTypeId = 1 AND t.TagName = '##TagName##' GROUP BY CASE WHEN LOWER(p.Title) LIKE '%##TagName##%' THEN 'yes' ELSE 'no' END