SQL Practice Logo

SQLPractice Online

Scenario SQL Question

Minimum and Maximum Salaries

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

Problem Statement

Return the lowest and highest salaries on the payroll in a single row. Use the column aliases min_salary and max_salary.

Relevant Tables

employees

SQL Concepts Used in This Scenario

Strengthen your understanding with these targeted learning topics: