Scenario SQL Question

Employee Tenure Calculation

Build mastery in Date Operations with this scenario-based SQL challenge and live execution support.

Problem Statement

Write a query to calculate the tenure (in years) of each employee from their hire date to today. Return employee_id, first_name, last_name, hire_date, and years_employed.

Relevant Tables

employees

SQL Concepts Used in This Scenario

Strengthen your understanding with these targeted learning topics:

Date & Time FunctionsSQL Fundamentals
Range & Interval FilteringAdvanced Filtering
NULL HandlingSQL Fundamentals