Customers Who Bought Both Products
Medium
Set Operations
Return customers who bought both 'Pen' and 'Book', using INTERSECT. Order by customer.
Table schema
Purchases(customer VARCHAR(10), product VARCHAR(10))Sample data
customer | product
Ann | Pen
Ann | Book
Bob | Pen
Cy | Book
Cy | Pen
Dee | Bag
Discussion
No discussions yet.
Shalyam Support
Hi! Ask us anything — we'll reply on WhatsApp or Telegram within 24 hours.