รับข้อมูลระหว่างปี 2010 ถึง 2012 ไม่จำเป็นต้องใช้ตารางทั้งหมด
get data between 2010 to 2012.It is not neccessary to use all the tables.
 CloseReasonTypes:  Id [ number]  Name [ text]  Description [ text] 
SELECT u.Id AS userID, u.Location AS userLocation, u.UpVotes AS userUpvotes, u.DownVotes AS userDownVotes, p.Id AS postID, p.ParentId AS parentPostID, p.CreationDate AS postCreationDate, p.DeletionDate AS postDeletionDate, p.Score AS postScore, p.ViewCount AS postViews, p.AnswerCount AS postAnswers, p.CommentCount AS postComments, p.FavoriteCount AS postFavorites, p.AcceptedAnswerId AS postAcceptedAns, v.Id AS voteID, v.CreationDate AS voteDate, v.BountyAmount AS voteBounty FROM Users AS u JOIN Posts AS p ON u.Id = p.OwnerUserId JOIN Votes AS v ON p.Id = v.PostId WHERE p.CreationDate BETWEEN '2010-09-11' AND '2012-09-11' ORDER BY p.CreationDate DESC