Scenario SQL Question

Count Distinct Job Titles

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

Problem Statement

Count how many distinct job_id values are actually held by at least one employee. (This may be fewer than the total number of jobs in the jobs table.) Return a single column named jobs_in_use.

Relevant Tables

employees

SQL Concepts Used in This Scenario

Strengthen your understanding with these targeted learning topics:

COUNT, SUM, AVG, MIN, MAXAggregate Functions & Grouping
GROUP BY FundamentalsAggregate Functions & Grouping
HAVING ClauseAggregate Functions & Grouping