Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close

Wrap course as a gift

Prepare your gift and double-check it looks just right.

Form validation errors

Recipient's Name:
Recipient's Email:
Your Message (Optional):
Proceed to Checkout

Creating Tables in SQL

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.