On January 21th at 14:15 UTC , progression through exercises will be unavailable for 10 minutes due to a planned maintenance break.
Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close
Introduction
2. The employee table
INSERT with SELECT
Referring to other tables
INSERT, UPDATE, and DELETE with subqueries
Summary

Instruction

We'll start with the employee table, which stores information about the employees who sell products to customers.

Exercise

Select all information from the employee table. This table has the following columns:

  • id – Identifies each employee.
  • first_name – The first name of the employee.
  • last_name – The last name of the employee.
  • salary – The employee's salary.