Sum Values of Each Element by Hour from Date to Date in SQL

Understanding the Difference Between Rows of the Same Column: Self-Joins, Window Functions, and Aggregations