Big Data Technology & Architecture

Aug 2, 2023 · Databases

SQL Interview Questions: YoY/MoM Growth Calculations and Finding Consecutive Numbers

This article provides interview‑style SQL examples that cover creating a sales table, computing year‑over‑year and month‑over‑month growth rates, and using various window‑function techniques to identify numbers that appear consecutively at least three times.