Practice Microsoft SQL Question | Real Coding Interviews

Quick Summary

Identify customers who have purchased at least one product from every available product category.
Requires comparing each customer's unique category count against the total number of distinct categories in the catalog.
Must account for duplicate transactions by counting categories only once per customer.

What This Tests

Common Patterns

Inner Join

Aggregation

Subquery

HAVING Filter

Test Cases

Input

Output

Expected