ระยะเวลาของ s' ไม่จำเป็นต้องใช้ตารางทั้งหมด
s' duration.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 p1.Title AS "Question Title", 'http://www.stackoverflow.com/questions/' + CAST(p1.Id AS TEXT) AS "URL", p1.ViewCount AS "Number of Views" FROM Posts AS p1, PostTags AS ptags1, Tags AS t1, PostTypes AS ptypes1 WHERE p1.PostTypeId = ptypes1.Id AND ptypes1.Id = 1 AND p1.Id = ptags1.PostId AND ptags1.TagId = t1.Id AND t1.TagName = '##TagName##' AND p1.CreationDate >= '##startdate##' AND p1.CreationDate <= '##enddate##' ORDER BY 'NUMBER OF VIEWS' DESC LIMIT 10