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

SQL / CHAPTER 02

SQL
Reports & joins.

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

10 lessons available

Learn0/10

Practice0/10

Challenges0/3

The foundations behind your ideas.

1. 01

   COUNT and NULL · Locked

   COUNT and NULL

   Open lesson
2. 02

   SUM, AVG, MIN, MAX · Locked

   SUM, AVG, MIN, MAX

   Open lesson
3. 03

   Grouping · Locked

   Grouping

   Open lesson
4. 04

   Filtering groups · Locked

   Filtering groups

   Open lesson
5. 05

   Keys and relationships · Locked

   Keys and relationships

   Open lesson
6. 06

   INNER JOIN · Locked

   INNER JOIN

   Open lesson
7. 07

   LEFT JOIN · Locked

   LEFT JOIN

   Open lesson
8. 08

   Rows without a match · Locked

   Rows without a match

   Open lesson
9. 09

   Counting after a JOIN · Locked

   Counting after a JOIN

   Open lesson
10. 10

    Customer report · Locked

    Customer report

    Open lesson