s และจำนวนการดูทั้งหมด เรียงลำดับอัตราการดูสูงสุดไปต่ำสุด ไม่จำเป็นต้องใช้ตารางทั้งหมด
s, and their total views, sorted highest view rate to lowestIt is not neccessary to use all the tables.
 CloseAsOffTopicReasonTypes:  Id [ number]  IsUniversal [ boolean]  InputTitle [ text]  MarkdownInputGuidance [ text]  MarkdownPostOwnerGuidance [ text]  MarkdownPrivilegedUserGuidance [ text]  MarkdownConcensusDescription [ text]  CreationDate [ time]  CreationModeratorId [ number]  ApprovalDate [ time]  ApprovalModeratorId [ number]  DeactivationDate [ time]  DeactivationModeratorId [ number] 
SELECT ViewCount, ROUND(CAST(ViewCount AS FLOAT) / DATEDIFF(dd, CreationDate, GETDATE()), 1) AS ViewsPerDay, Id AS "post_link" FROM Posts WHERE PostTypeId = 1 AND OwnerUserId = '##UserId##' ORDER BY ViewCount DESC