Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close

Wrap course as a gift

Prepare your gift and double-check it looks just right.

Form validation errors

Recipient's Name:
Recipient's Email:
Your Message (Optional):
Proceed to Checkout

Creating Basic SQL Reports in PostgreSQL

Introduction
Get to know the database
3. The employees table
Summary

Instruction

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.

Exercise

Select all the information from the employees table.

Stuck? Here's a hint!

Use an asterisk (*) to select all columns.