Advanced SQL

You can write SELECT, JOIN and GROUP BY, yet the real requests keep arriving: the top orders in every region, a running total that restarts each month, a moving average, the longest streak of daily logins, everyone under a given manager at any depth. This book teaches the patterns behind those reports. You learn window functions with ranking, frames, lag and lead, then common table expressions and...