Scenario SQL Question

Employees Above Job Minimum Salary

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

Problem Statement

Find employees whose salary is more than 30% above their job's minimum salary (i.e. salary > min_salary * 1.3). Return employee_id, first_name, last_name, salary, job_title, min_salary — ordered by salary DESC, employee_id.

Relevant Tables

employeesjobs

SQL Concepts Used in This Scenario

Strengthen your understanding with these targeted learning topics:

INNER JOIN Deep DiveJoins & Relationships
LEFT/RIGHT/FULL OUTER JOINJoins & Relationships
Multiple Table JoinsJoins & Relationships