ผู้ใช้ SO 300 อันดับแรกจากปูเน่ ไม่จำเป็นต้องใช้ตารางทั้งหมด
Top 300 SO Users from Pune.It is not neccessary to use all the tables.
 PostTypes:  Id [ number]  Name [ text] 
SELECT ROW_NUMBER() OVER (ORDER BY Reputation DESC) AS "#", Id AS "user_link", Reputation, Location FROM Users WHERE LOWER(Location) LIKE '%pune%' OR UPPER(Location) LIKE '%PUNE%' OR Location LIKE '%Pune%' AND Reputation >= 1000 ORDER BY Reputation DESC LIMIT 300