interviewReal Business Cases 12m est

Cross-Category Brand Buyers

Problem Statement

Identify customers who have purchased products in BOTH the 'Electronics' and the 'Home' categories. Retrieve their customer `id` and `name`.

Skills Evaluated

INTERSECTJOINSubqueries
Write your SQL query in the editor on the right and click **Run Query**. The system runs your query and compares the result dataset with the official solution. Results must match row-for-row, column-for-column.

Expected Output Format

Executing expected result set...
SQL Query WorkspaceSQLite v3.45 (WASM Mode)
QUICK INSERT:
1