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


Let's start with the employees table.

It stores information about the people employed at Northwind. Each employee has:

  • A unique ID (employee_id).
  • A first and last name (first_name and last_name).
  • A professional title (title).

Pay attention to the column named reports_to, which contains the employee ID (from the same table) of the employee's manager. There are also other informative columns in this table, such as hire_date and address.


Select all the information from the employees table.

Stuck? Here's a hint!

Use an asterisk (*) to select all columns.