Calculating the Average of Last 3 Values for Each User in SQL

Understanding the Problem with UNION Statements in SQLite: A Clever Solution Using CTEs

Declaring Aliases Before SELECT: A Deep Dive into SQL