Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close
2. Get to know the WorkshopWorkers table
Dictionary database


We'll start with the WorkshopWorkers table from the Sesame Brothers Workshop.


The WorkshopWorkers table consists of a few columns:

  • Id – the ID of a given worker,
  • Name – the first and last name of a given worker,
  • Specialization – a given worker's specialization,
  • MasterId – the ID of a given worker's supervisor,
  • Experience – number indicating a given worker's years of experience, and
  • ProjectId – the ID of the project a given worker is currently assigned.

Show all workers' names together with the names of their direct supervisors. Rename columns to ApprenticeName and MasterName, respectively.

Stuck? Here's a hint!

You have to give an alias to either both or at least one table. Type:

  Apprentice.Name ApprenticeName,
  Master.Name MasterName
FROM WorkshopWorkers Apprentice
JOIN WorkshopWorkers Master
  ON Apprentice.MasterId = Master.Id