Scenario SQL Question

Employee Tenure Calculation

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

Problem Statement

Compute each employee's completed years of service as of the fixed reference date 2025-01-01. Return employee_id, first_name, last_name, hire_date, and years_employed — ordered by years_employed DESC, employee_id.

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