, ตอบ ไม่จำเป็นต้องใช้ทุกตาราง
, answer.It is not neccessary to use all the tables.
 PostHistoryTypes:  Id [ number]  Name [ text] 
SELECT P.Id AS "post_link", R.MaxScore, R.PostType FROM Posts AS P INNER JOIN (SELECT MAX(PO.Score) AS MaxScore, PT.Name AS PostType FROM Posts AS PO INNER JOIN PostTypes AS PT ON PT.Id = PO.PostTypeId AND PT.Id IN (1, 2) WHERE PO.DeletionDate IS NULL GROUP BY PT.Name) AS R ON R.MaxScore = P.Score