Quiz

Instruction

Ok, now that we have the view ready, let's use it in a complicated query.

Exercise

Ok, we have the view young_participants, we want to show their first_name and last_name together with the name of the competition they take part in. Write the proper SQL statement with JOINs. Use the ERD below to help you.

Participant and competition tables

Stuck? Here's a hint!

Take a look at Part 7 if you don't remember views and JOINs with them.

Console

Code editor

Result

TableConsole