ผู้ร่วมให้ข้อมูล Android อันดับต้นๆ ในสเปน && เยอรมนี ไม่จำเป็นต้องใช้ตารางทั้งหมด
Top Android Contributors in Spain && Germany.It is not neccessary to use all the tables.
 ReviewTaskResultTypes:  Id [ number]  Name [ text]  Description [ text] 
WITH USER_BY_TAG AS (SELECT ROW_NUMBER() OVER (ORDER BY COUNT(*) DESC) AS Rank, u.Id AS "user_link", u.Location, 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 VoteTypeId = 2 INNER JOIN Users AS u ON u.Id = p.OwnerUserId WHERE (LOWER(Location) LIKE '%germany%' OR LOWER(Location) LIKE '%spain%') AND TagName = 'android' GROUP BY u.Id, TagName, Location) SELECT * FROM USER_BY_TAG WHERE rank <= 1000 ORDER BY UpVotes DESC