Scenario SQL Question

Employees with Same Job as John Smith

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

Problem Statement

Find every employee in the same job as Alice Johnson, excluding Alice herself. Use a scalar subquery to get her job_id. Return employee_id, first_name, last_name, job_id — ordered by employee_id.

Relevant Tables

employees

SQL Concepts Used in This Scenario

Strengthen your understanding with these targeted learning topics:

Subquery Types & ClassificationSubqueries & CTEs
Correlated SubqueriesSubqueries & CTEs
Common Table ExpressionsSubqueries & CTEs