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

The Basics of Creating Tables in SQL

Introduction
Foreign keys
Multi-column Foreign Keys
Summary

Instruction

Cool! That's it. Now that we have the tables ready, let's try to query our database.

Exercise

Select first_name and last_name of each employee along with the title of their current position. Use the ERD below to help you.

LEAD

Hints:

  • You will need to use JOIN twice to join the three tables.
  • If you only want to retrieve the current position of each employee, remember that the stored end_data for that particular row in job_history will be NULL.

Stuck? Here's a hint!

Type:

SELECT e.first_name, e.last_name, p.title
FROM employee e
INNER JOIN job_history j
  ON e.id = j.employee_id
JOIN position p
  ON j.position_id = p.id
WHERE end_date IS NULL;