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.
| customer_id | name | city | segment | signup_date |
|---|---|---|---|---|
| 1 | Aarav Sharma | Jaipur | Retail | 2023-01-15 |
| 2 | Priya Iyer | Chennai | Corporate | 2023-03-02 |
| 3 | Rohan Mehta | Mumbai | Retail | 2023-06-20 |
| 4 | Sneha Reddy | Hyderabad | SMB | 2023-08-11 |
| 5 | Vikram Singh | Delhi | Corporate | 2024-01-05 |
| order_id | customer_id | region | product | qty | amount | order_date |
|---|---|---|---|---|---|---|
| 1 | 1 | N | Laptop | 1 | 1.0 | NULL |
| 2 | 1 | N | Phone | 1 | 1.0 | NULL |
| 3 | 2 | N | Laptop | 1 | 1.0 | NULL |
| 4 | 2 | N | Mouse | 1 | 1.0 | NULL |
| 5 | 3 | N | Phone | 1 | 1.0 | NULL |
| product | category | price |
|---|---|---|
| Laptop | Electronics | 55000.0 |
| Phone | Electronics | 30000.0 |
| Mouse | Accessories | 500.0 |
| Desk | Furniture | 12000.0 |
| Chair | Furniture | 7000.0 |
| customer_id | name |
|---|---|
| 1 | Aarav Sharma |
| customer_id | name | city | segment | signup_date |
|---|---|---|---|---|
| 11 | Ananya Gupta | Pune | NULL | 2024-02-14 |
| 12 | Karan Joshi | Indore | Retail | 2024-03-30 |
| 13 | Ishaan Malhotra | Bengaluru | SMB | 2022-05-01 |
| order_id | customer_id | region | product | qty | amount | order_date |
|---|---|---|---|---|---|---|
| 1 | 11 | N | Tablet | 1 | 1.0 | NULL |
| 2 | 11 | N | Monitor | 1 | 1.0 | NULL |
| 3 | 12 | N | Tablet | 1 | 1.0 | NULL |
| 4 | 13 | N | Monitor | 1 | 1.0 | NULL |
| 5 | 13 | N | Tablet | 1 | 1.0 | NULL |
| product | category | price |
|---|---|---|
| Tablet | Electronics | 22000.0 |
| Monitor | Electronics | 22000.0 |
| Keyboard | Accessories | 1500.0 |
| Webcam | Accessories | 1500.0 |
| Sofa | Furniture | 45000.0 |
| Lamp | Furniture | 800.0 |
| customer_id | name |
|---|---|
| 11 | Ananya Gupta |
| 13 | Ishaan Malhotra |
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 ›
{{ 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.
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.statement }}
{{ p.constraints }}
No submissions yet. Press Submit to judge your code against all tests.
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.
{{ p.solution }}
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.
Create your free TechTown account to unlock every problem, track your progress, bookmark questions and keep preparing for interviews.