Fetching Details of the Most Recently Hired Employee from Northwind Database

Easy
8
86.5% Acceptance

In this lab, you'll be working with the database, specifically focusing on the employees table. Your task is to write an SQL query to fetch details about the most recently hired employee.

Objective

Your SQL query should return the first_name, last_name, and hire_date of the employee who was hired most recently.

Schema

Schema of the employees table for reference

  • employee_id
  • last_name
  • first_name
  • title
  • title_of_courtesy
  • birth_date
  • hire_date
  • address
  • city
  • region
  • postal_code
  • country
  • home_phone
  • extension
  • reports_to

Concepts

  • SELECT: To choose the columns you want to display.
  • MAX: To find the highest value in a numeric field.

The final column names must be first_name, last_name, and hire_date

Good luck!