Customers Buying Every Category

Databricks

Interview Core Track · Hard · 35 min

Databricks wants a scorecard for customers buying every category. Return each customer_id that purchased at least one product in every product_category. Sort...

Interview Core Track

Hard

35 min

query basics

joins

Company labels are directional practice context, not official interview guidance.

Timer 00:00

Back to practice

Objective

Practice query basics through a Databricks-tagged business scenario.

Approach

Use this track to improve speed, edge-case handling, and accuracy under timed conditions.

Company context

Company labels are directional practice context, not official interview guidance.

Prereq: query basics

Prereq: filtering

Databricks wants a scorecard for customers buying every category. Return each customer_id that purchased at least one product in every product_category. Sort by customer_id.

Pro question

This is a Pro question

Upgrade to Pro to unlock this prompt, the SQL workspace, and all 254 problems.

Upgrade to Pro — unlock all 254 problems

Editor

SQL workspace

Run queries against the protected question data, then submit once the result shape looks right.

Sign in to run SQL

Create a free account or sign in before running queries against protected question data.