Customers Who Bought Every Electronics Product

PySpark practice question · Hard · Joins

Relational division: return customers who have ordered EVERY product in the 'Electronics' category (at least once each; extra purchases of other categories are fine). Assume the category has at least one product. Return customer_id and name. Row order does not matter.

Example 1

Input customers
customer_idnamecitysegmentsignup_date
1Aarav SharmaJaipurRetail2023-01-15
2Priya IyerChennaiCorporate2023-03-02
3Rohan MehtaMumbaiRetail2023-06-20
4Sneha ReddyHyderabadSMB2023-08-11
5Vikram SinghDelhiCorporate2024-01-05
Input orders
order_idcustomer_idregionproductqtyamountorder_date
11NLaptop11.0NULL
21NPhone11.0NULL
32NLaptop11.0NULL
42NMouse11.0NULL
53NPhone11.0NULL
Input products
productcategoryprice
LaptopElectronics55000.0
PhoneElectronics30000.0
MouseAccessories500.0
DeskFurniture12000.0
ChairFurniture7000.0
Expected output
customer_idname
1Aarav Sharma

Example 2

Input customers
customer_idnamecitysegmentsignup_date
11Ananya GuptaPuneNULL2024-02-14
12Karan JoshiIndoreRetail2024-03-30
13Ishaan MalhotraBengaluruSMB2022-05-01
Input orders
order_idcustomer_idregionproductqtyamountorder_date
111NTablet11.0NULL
211NMonitor11.0NULL
312NTablet11.0NULL
413NMonitor11.0NULL
513NTablet11.0NULL
Input products
productcategoryprice
TabletElectronics22000.0
MonitorElectronics22000.0
KeyboardAccessories1500.0
WebcamAccessories1500.0
SofaFurniture45000.0
LampFurniture800.0
Expected output
customer_idname
11Ananya Gupta
13Ishaan Malhotra

Constraints

Return exactly customer_id, name.

Solve it in the live editor on this page — run on sample data, then submit against hidden tests.

‹ Employees Earning More Than Their Manager · Remove Exact Duplicate Rows ›

Customers Who Bought Every Electronics Product – PySpark Interview Question | TechTown
T
Tech Town
Hi, {{ authName }} · Dashboard Log Out Log In Sign Up Free
PySpark Interview Practice

Practice PySpark Online

{{ totalCount }} questions · {{ shHardPct }}% Hard. Real PySpark DataFrame and Spark SQL interview questions. Write PySpark in your browser on TechTown’s Spark engine, run sample tests, then submit against hidden tests.

{{ totalCount }}
Questions
{{ shTopicCount }}
Topics
{{ solvedCount }}
Solved
{{ accuracy }}
Acceptance
Bookmark Question Topic Difficulty Status
{{ r.n }} - {{ r.title }}{{ r.badge }}{{ r.lock }} {{ r.topic }} {{ r.difficulty }} {{ r.statusIcon }}
No questions match these filters.
Showing {{ shRange }} of {{ shFilteredCount }}

Guests can solve {{ freeLimit }} problems for free. Log in or sign up (free) to unlock everything, keep your streak and appear on the leaderboard. New to a topic? Learn it first in the Spark course.

{{ p.num }}. {{ p.title }} {{ p.difficulty }} {{ p.topic }} {{ p.solvedLabel }}
{{ shPointsLabel }} ⏱ {{ shTimer }}
Embed this questionPaste on a blog, course page or LMS. Free to use — educator guide
{{ shEmbedCode }}

{{ p.statement }}

Example {{ ex.n }}
{{ tb.title }}
{{ c.v }}
Expected result
{{ c.v }}
Constraints

{{ p.constraints }}

  1. {{ h }}
Learn the concept first: {{ p.topic }} in the Spark course
Your submissions (last 20, saved on this device)

No submissions yet. Press Submit to judge your code against all tests.

{{ sb.verdict }}
{{ sb.meta }}
🔒 Solution locked

The model solution and step-by-step explanation unlock when you solve this problem or after 3 unsuccessful submissions ({{ shFailsLabel }}). Struggling? Try the hints on the Question tab first.

Why this approach — step by step
  1. {{ st }}
Optimal solution (PySpark)
{{ p.solution }}
Runs in an isolated browser sandbox · {{ engineLabel }}

Write real PySpark: from pyspark.sql import functions as F, Window, spark.sql(...). It runs in your browser on a lightweight Spark engine, and the same code runs unchanged on Databricks or any Spark cluster. Use df.show() or print() to debug.

{{ verdict }} {{ verdictDetail }}
{{ errorText }}
{{ tr.label }} {{ tr.msg }}
Expected
{{ c.v }}
Your output
{{ c.v }}
stdout:
{{ stdout }}

Enjoying your practice journey?

Create your free TechTown account to unlock every problem, track your progress, bookmark questions and keep preparing for interviews.

Log in / Sign up