Scenario SQL Question

Compare Employee to Their Manager on Multiple Attributes

Build mastery in Self Joins Hierarchical with this scenario-based SQL challenge and live execution support.

Problem Statement

Write a query to compare each employee with their manager on salary, experience, and hire date. Return employee_name, manager_name, salary_comparison, experience_comparison, and hire_date_comparison.

Relevant Tables

employees

SQL Concepts Used in This Scenario

Strengthen your understanding with these targeted learning topics:

Self JoinsJoins & Relationships
Recursive CTEs for Hierarchical DataSubqueries & CTEs
Common Table ExpressionsSubqueries & CTEs