Scenario SQL Question

Calculate Commission Based on Sales Tier

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

Problem Statement

Compute each salesperson's commission: 5% if total sales < 50000, 10% if 50000-100000 inclusive, 15% if > 100000. Return salesperson_id, salesperson_name, total_sales, commission — ordered by salesperson_id.

Relevant Tables

sales

SQL Concepts Used in This Scenario

Strengthen your understanding with these targeted learning topics:

CASE Statements & Conditional LogicSQL Fundamentals
Conditional Aggregation with CASE & FILTERAggregate Functions & Grouping
Complex WHERE Conditions & Boolean LogicAdvanced Filtering