Angular vs Ember vs React เมื่อเดือนที่แล้ว ไม่จำเป็นต้องใช้ตารางทั้งหมด
Angular vs Ember vs React last Month.It is not neccessary to use all the tables.
 SuggestedEditVotes:  Id [ number]  SuggestedEditId [ number]  UserId [ number]  VoteTypeId [ number]  CreationDate [ time]  TargetUserId [ number]  TargetRepChange [ number] 
SELECT rate.TagName AS Tag, ROW_NUMBER() OVER (ORDER BY rate.Rate DESC) AS Rank, rate.Rate AS NumQuestions FROM (SELECT COUNT(PostId) AS Rate, TagName FROM Tags, PostTags, Posts WHERE Tags.Id = PostTags.TagId AND Posts.Id = PostId AND Posts.CreationDate > DATEADD(Month, -1, GETDATE()) AND TagName IN ('angularjs', 'ember.js', 'reactjs') GROUP BY TagName) AS rate ORDER BY rate.rate DESC