ผู้ใช้ TensorFlow 100 อันดับแรกตามสถานที่ ไม่จำเป็นต้องใช้ตารางทั้งหมด
Top 100 TensorFlow users by location.It is not neccessary to use all the tables.
 PostHistory:  Id [ number]  PostHistoryTypeId [ number]  PostId [ number]  RevisionGUID [ other]  CreationDate [ time]  UserId [ number]  UserDisplayName [ text]  Comment [ text]  Text [ text]  ContentLicense [ text] 
SELECT u.Id AS "user_link", COUNT(*) AS UpVotes FROM Tags AS t INNER JOIN PostTags AS pt ON pt.TagId = t.Id INNER JOIN Posts AS p ON p.ParentId = pt.PostId INNER JOIN Votes AS v ON v.PostId = p.Id AND v.VoteTypeId = 2 INNER JOIN Users AS u ON u.Id = p.OwnerUserId WHERE p.CommunityOwnedDate IS NULL AND LOWER(t.TagName) = 'tensorflow' AND (LOWER(Location) LIKE ('%location%') OR Location LIKE '%location%' AND LENGTH(Location) > 1) GROUP BY u.Id ORDER BY UpVotes DESC LIMIT 100