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


Okay! Here comes the last part of our course – the challenge.

We'll work with two sets of tables, with five exercises each. There are no hints, and you can expect to encounter any kind of JOIN that we covered throughout this course.

In the first section of the challenge we'll work with data from La Lingua, a small language school. The first table contains lecturers.


Select all data from the lecturer table. It consists of the following columns:

  • id – the id of a given lecturer,
  • name – the first and last name of a given lecturer, and
  • language – the language a given lecturer teaches.