SQL for Analytics

Turning business questions into queries: metrics, retention, funnels and trends.

  1. 01

    Define Daily Active Users

    • easy
  2. 02

    Pivot Rows into Columns

    • medium
    • Pro
  3. 03

    Seven-Day Moving Average

    • medium
    • Pro
  4. 04

    Compare Week on Week

    • medium
    • Pro
  5. 05

    Build a Conversion Funnel

    • medium
    • Pro
  6. 06

    Median and Percentiles

    • medium
    • Pro
  7. 07

    Cohort Retention

    • hard
    • Pro
  8. 08

    Group Events into Sessions

    • hard
    • Pro