Simple JOINs recap
Various kinds of JOINs
Filtering with LEFT JOIN and RIGHT JOIN
Summary
17. Get ready

Instruction

Now, we'll consolidate our knowledge with four exercises. However, this time we won't explain the tables. This is to better simulate the reality of SQL programming — which is that sometimes, you don't have access to proper database documentation. Don't worry, just take a look at the Database tab on the right: you can easily guess the purpose of each column.

Good luck!

Exercise

Click the Next exercise button to continue.

Console

Code editor

Result

TableConsole