The "Six SQL patterns I use to catch transaction fraud" thread here was great, and every one of those patterns is a rule: you know what fraud looks like, you write the WHERE clause.…
The five cleaning rules behind a median of +346 Instagram followers in 30 days across 981 accounts - nearest-reading windows, survivor-only counts, medians, a 5x jump filter and a stale-reading cutoff, with a SQL sketch.