Window functions vs Aggregate functions

Introduction SQL is often introduced as a language for retrieving data, but for data...