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 (EmployeeID).
  • A first and last name (FirstName and LastName).
  • A professional title (Title).

Pay attention to the column named ReportsTo, 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 HireDate and Address.


Select all the information from the Employees table.

Stuck? Here's a hint!

Use an asterisk (*) to select all columns.