book

modern-sql

index

use-the-index-luke

window function

sqlite:Window Functions wiki:window function