Nombre de r ponses par utilisateur haute r putation ไม่จำเป็นต้องใช้ตารางทั้งหมด
Nombre de r ponses par utilisateur haute r putation.It is not neccessary to use all the tables.
 PostNoticeTypes:  Id [ number]  ClassId [ number]  Name [ text]  Body [ text]  IsHidden [ boolean]  Predefined [ boolean]  PostNoticeDurationId [ number] 
SELECT u.Id, u.Reputation, u.DisplayName, TIME_TO_STR(p.CreationDate, '%YEAR') AS Year, TIME_TO_STR(p.CreationDate, '%-mONT%-H') AS Month, COUNT(*) AS Count FROM Users AS u INNER JOIN Posts AS p ON u.Id = p.OwnerUserId WHERE TIME_TO_STR(p.CreationDate, '%Year') = 2017 AND p.PostTypeId = 2 AND u.Reputation >= 20000 GROUP BY u.Id, u.Reputation, u.DisplayName, TIME_TO_STR(p.CreationDate, '%YEAR'), TIME_TO_STR(p.CreationDate, '%-mONT%-H') ORDER BY -Reputation, u.Id, Year, Month