Working with data in SQL.
A lightweight in-process SQL OLAP engine, powered by ClickHouse.
Inserting and updating data with a single query.
The many faces of JOIN in SQL.
Seriously, I don't. I'd prefer SQL.
Allows executing queries without touching the table.
Calculate the difference between each record and the previous or next one.
According to the standard, we should use be using FETCH.
Assigning each record to a specific segment based on the value of one or more columns.
For those who knew SQL, but kinda forgot it.
Assigning a rank to each row based on the value of one or more columns.
Moving averages, cumulative totals and other sliding aggregates.
Comparing individual values with totals and averages.
Comparing records with neighbors and boundaries.
Making ratings and dividing data into partitions.
To build great analytical reports without Excel or Pandas.
A clear and visual introduction to window functions in SQL.
Use them instead of subqueries.
CC-licensed design guide for presentations, reports, and dashboards.
