SQL Arena
Track · Analyst

ClickHouse: analytics on a columnar database

Tasks written for ClickHouse itself: aggregates over large tables, arrays, window functions. The dialect differs from PostgreSQL not in syntax but in what is cheap — and the tasks show it.

32 tasks~10 h4 modules

Track program

4 modules
  1. 1
    Module 1

    First queries

    10 tasks
  2. 2
    Module 2

    Grouping and aggregates

    8 tasks
  3. 3
    Module 3

    Arrays

    7 tasks
  4. 4
    Module 4

    Window functions

    7 tasks

Who it's for

A track for data analysts. Tasks run from the basics to the advanced, grading is automatic, and both PostgreSQL and MySQL are supported.

Back to tracks