Python gold badgers เรียงลำดับตามวันที่ ไม่จำเป็นต้องใช้ตารางทั้งหมด
Python gold badgers ordered by date.It is not neccessary to use all the tables.
 CloseReasonTypes:  Id [ number]  Name [ text]  Description [ text] 
SELECT ROW_NUMBER() OVER (ORDER BY b.Date DESC), b.UserId AS "user_link", b.Date AS got_gold_python, u.Reputation AS rep FROM Users AS u, Badges AS b WHERE b.Name = 'python' AND b.Class = 1 AND u.Id = b.UserId GROUP BY b.Date, b.UserId, u.Reputation