.ไม่จำเป็นต้องใช้ทุกตาราง
.It is not neccessary to use all the tables.
 PostTypes:  Id [ number]  Name [ text] 
WITH GitHubUsers AS (SELECT u.Id, COUNT(a.Id) AS answersCount, SUM(a.Score) AS answersScore FROM Users AS u LEFT JOIN Posts AS a ON a.PostTypeId = 2 AND a.OwnerUserId = u.Id WHERE u.WebsiteUrl LIKE '%github%' GROUP BY u.Id) SELECT u.Id, u.WebsiteUrl, u.UpVotes, u.Reputation, u.AboutMe, g.answersCount, g.answersScore FROM GitHubUsers AS g JOIN Users AS u ON u.Id = g.Id WHERE answersCount >= 1