SQL Basics

Read and explain everyday SQL queries: filtering, sorting, grouping and handling missing values.

  1. 01

    Select, Filter and Sort

    • easy
  2. 02

    Count, Sum and Average

    • easy
    • Pro
  3. 03

    Group By Explained

    • easy
    • Pro
  4. 04

    Where or Having?

    • medium
    • Pro
  5. 05

    The Trouble with Null

    • medium
    • Pro
  6. 06

    Subqueries and Common Table Expressions

    • medium
    • Pro
  7. 07

    Window Functions

    • hard
    • Pro