โหวตขึ้นและลงตามชั่วโมงของวันของคำตอบที่ยอมรับ ไม่จำเป็นต้องใช้ตารางทั้งหมด
Up vs Down votes by hour of day of Accepted Answer.It is not neccessary to use all the tables.
 PendingFlags:  Id [ number]  FlagTypeId [ number]  PostId [ number]  CreationDate [ time]  CloseReasonTypeId [ number]  CloseAsOffTopicReasonTypeId [ number]  DuplicateOfQuestionId [ number]  BelongsOnBaseHostAddress [ text] 
SELECT TIME_TO_STR(p.CreationDate, '%-HOUR') AS Hour, COUNT(*) AS Amount, SUM(CASE WHEN VoteTypeId = 2 THEN 1 ELSE 0 END) AS UpVotes, SUM(CASE WHEN VoteTypeId = 3 THEN 1 ELSE 0 END) AS DownVotes, (CAST(SUM(CASE WHEN VoteTypeId = 2 THEN 1 ELSE 0 END) AS FLOAT) / CAST(SUM(CASE WHEN VoteTypeId = 3 THEN 1 ELSE 0 END) AS FLOAT)) AS UpVoteDownVoteRatio FROM Votes AS v JOIN Posts AS p ON v.PostId = p.AcceptedAnswerId WHERE PostTypeId = 1 AND NOT AcceptedAnswerId IS NULL GROUP BY TIME_TO_STR(p.CreationDate, '%-HOUR') ORDER BY TIME_TO_STR(p.CreationDate, '%-HOUR')