◈ Code Lab is in development. New lessons and improvements are on the way. Progress can be deleted.

SQL / CHAPTER 06

SQL
Analytics.

Learn SQL with real tables and PostgreSQL in your browser. Learn and Practice per topic, separate challenges.

Choose a section

LearnPracticeChallenges

Lesson with explanation and a guided task. Theory stays readable; completion requires a passing solution.

Challenges are optional and do not block the next chapter.

Start lesson Random task

SQL

11 lessons available

Learn0/11

Practice0/11

Challenges0/3

The foundations behind your ideas.

1. 01

   Dates: DATE and TIMESTAMP · Locked

   Dates: DATE and TIMESTAMP

   Open lesson
2. 02

   INTERVAL and period bounds · Locked

   INTERVAL and period bounds

   Open lesson
3. 03

   date_trunc by month · Locked

   date_trunc by month

   Open lesson
4. 04

   GROUP BY vs window · Locked

   GROUP BY vs window

   Open lesson
5. 05

   OVER (PARTITION BY ...) · Locked

   OVER (PARTITION BY ...)

   Open lesson
6. 06

   ROW_NUMBER · Locked

   ROW_NUMBER

   Open lesson
7. 07

   RANK and DENSE_RANK · Locked

   RANK and DENSE_RANK

   Open lesson
8. 08

   SUM, AVG and COUNT with OVER · Locked

   SUM, AVG and COUNT with OVER

   Open lesson
9. 09

   Running total · Locked

   Running total

   Open lesson
10. 10

    Frames and moving average · Locked

    Frames and moving average

    Open lesson
11. 11

    Sales trends · Locked

    Sales trends

    Open lesson