แท็ก StackOverflow ที่ได้รับความนิยมมากที่สุดใน <ปี> ไม่จำเป็นต้องใช้ตารางทั้งหมด
Most popular StackOverflow tags in <year>.It is not neccessary to use all the tables.
 PostsWithDeleted:  Id [ number]  PostTypeId [ number]  AcceptedAnswerId [ number]  ParentId [ number]  CreationDate [ time]  DeletionDate [ time]  Score [ number]  ViewCount [ number]  Body [ text]  OwnerUserId [ number]  OwnerDisplayName [ text]  LastEditorUserId [ number]  LastEditorDisplayName [ text]  LastEditDate [ time]  LastActivityDate [ time]  Title [ text]  Tags [ text]  AnswerCount [ number]  CommentCount [ number]  FavoriteCount [ number]  ClosedDate [ time]  CommunityOwnedDate [ time]  ContentLicense [ text] 
SELECT PostId, TagName FROM Tags, PostTags, Posts WHERE Tags.Id = PostTags.TagId AND Posts.Id = PostId AND Posts.CreationDate >= '2012-01-01' AND Posts.CreationDate < '2012-02-01' AND TagName IN ('javascript', 'java', 'php', 'c#', 'html', 'python', 'css', 'c++', 'mysql', 'sql', 'objective-c', 'asp.net', 'c', 'json', 'r', 'ruby', '.net', 'xml', 'html5', 'vb.net', 'swift', 'bash', 'matlab', 'vba', 'css3', 'python-2.7', 'scala', 'excel-vba', 'shell', 'perl', 'jsp', 'xaml', 'powershell', 'batch-file', 'c++11', 'python-3.x', 'tsql', 'haskell', 'delphi', 'actionscript-3')