EXCEPT with Aggregation for Gap Analysis
Hard
set-operations
Bloomberg
Salesforce
Oracle
Write a query using EXCEPT to find product categories that exist in the catalog but have never been ordered. Return category, ordered alphabetically.
Expected Output: Categories with no orders.
Tables
Hints (3 available)
SQL Editor
Output
Click "Run" to see results...