จำนวนโพสต์ตามอายุและตำแหน่งของผู้ใช้ ไม่จำเป็นต้องใช้ตารางทั้งหมด
Number of posts by user age and location.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 a2."age" AS "UsersCopyAge", a2.Location AS "UsersCopyLocation", COUNT(*) AS "count_posts" FROM "Posts " AS a1 LEFT OUTER JOIN Users AS a2 ON (a2.Id = a1."LastEditorUserId ") WHERE (a2.Location IN ('France', 'India')) GROUP BY a2."age", a2.Location ORDER BY 'UsersCopyAge' DESC, 'UsersCopyLocation' DESC