sql CTEs, window functions, B+tree indexes.

all five