Kickstart 2020 with new opportunities! - 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.