Can't figure out how to setup my db and query

[Teodor]

and maybe check this as well:

Advanced Multi Level Nested Queries with the Database Query Builder

Intro You already know how to create nested database queries in the database query builder in order to access nested data in a single database query. In this tutorial we will show you a more advanced examples, using 3 levels of nested data and database joins. We want to display courses, the students enrolled in each course and also all the courses each of the student is enrolled in. This means the final result will be a 3 level nested query: > Course Name > Student > All the cours…