SQL: Complex Join — Sales Report
Medium
SQL — Joins
SQL
Multi-Join
Aggregation
Multi-table join for sales summary by region and category.
Constraints
Write standard SQL (MySQL 8.0 compatible).
Examples
Example 1:
Input: See example
Output:
Example 2:
Input: See example
Output:
Hints
JOIN 3+ tables with aggregation.
Tests:
Runtime:
Memory:
Test
Input:
Expected:
Got:
Click Run Code to test against sample cases, or Submit to test against all cases.
▲ Console