LAG for prior day

LAG with PARTITION BY

RANK present

DENSE_RANK present

Both rank functions used

SUM OVER for running total

AVG OVER for moving average

Moving average window frame

No SELECT *

PARTITION BY category

Notes file present

SELECT * removed

Keyset pagination used

NOT IN replaced

Date function removed

N+1 fixed

B-tree for range/sort

Hash for equality

GIN for arrays

GIN for JSONB

Covering index

Review document present

Multiple CTEs used

CTEs are chained

LEFT JOIN for all users

COALESCE for NULL counts

No SELECT *

Date range not function-wrapped

Dormant users identified

NOT IN avoided

Recently active flag

Notes file present