SQL Window Functions. Data Analysis in Practice

Anton Zhiyanov is a Go developer and SQLite enthusiast, and a specialist in working with source code. "SQL Window Functions" is a book about a powerful tool for data analysis that allows you to perform complex calculations and obtain information about groups of rows or window results, but briefly — how to create great analytical reports without the involvement of "Excel". Together with Anton Zhiyanov, we will explore the basics of SQL: • what a "window" is in SQL and how it works; • about frames and how to work with them; • and of course, we will perform practical assignments in the sandbox. The book will be useful for both novice developers and experienced specialists who want to expand and solidify their knowledge in the field of SQL window functions.