Challenge time

Instruction

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.

Exercise

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.

Console

Code editor

Result

TableConsole