จำนวนการดู โพสต์ทั้งหมด และเจ้าของทั้งหมดสำหรับคำถามที่สร้างขึ้นในปี 2560 ไม่จำเป็นต้องใช้ตารางทั้งหมด
Number of Views, Total Posts and Total Owners for Questions created in 2017.It is not neccessary to use all the tables.
 Users:  Id [ number]  Reputation [ number]  CreationDate [ time]  DisplayName [ text]  LastAccessDate [ time]  WebsiteUrl [ text]  Location [ text]  AboutMe [ text]  Views [ number]  UpVotes [ number]  DownVotes [ number]  ProfileImageUrl [ text]  EmailHash [ text]  AccountId [ number] 
SELECT SUM(ViewCount) AS total_views, COUNT(DISTINCT Id) AS post_cnt, COUNT(DISTINCT OwnerUserId) AS total_users_owners FROM Posts WHERE YEAR(CreationDate) = '2017'