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

SQL / CHAPTER 05

SQL
Advanced queries.

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

   CASE WHEN: categories · Locked

   CASE WHEN: categories

   Open lesson
2. 02

   Scalar subquery · Locked

   Scalar subquery

   Open lesson
3. 03

   IN with a subquery · Locked

   IN with a subquery

   Open lesson
4. 04

   EXISTS · Locked

   EXISTS

   Open lesson
5. 05

   Correlated subquery · Locked

   Correlated subquery

   Open lesson
6. 06

   NOT IN, NULL and NOT EXISTS · Locked

   NOT IN, NULL and NOT EXISTS

   Open lesson
7. 07

   Subquery in FROM · Locked

   Subquery in FROM

   Open lesson
8. 08

   CTE with WITH · Locked

   CTE with WITH

   Open lesson
9. 09

   Sequential CTEs · Locked

   Sequential CTEs

   Open lesson
10. 10

    UNION and UNION ALL · Locked

    UNION and UNION ALL

    Open lesson
11. 11

    Monthly report · Locked

    Monthly report

    Open lesson