SQL Practice Logo

SQLPractice Online

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 all employees who have the same job as John Smith using a subquery.

Relevant Tables

employees

SQL Concepts Used in This Scenario

Strengthen your understanding with these targeted learning topics: