Save up to $499! Grab all Python courses for $49 or all online courses we’ve ever launched for only $169. Only Feb 11-16. Happy Valentine's!
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.