Skip to main content
Admissions guidance, study banks, and career tools — get started on Shalyam

Customers Who Bought Both Products

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.

Rewards · v2.1

Get Exclusive Insights with Every Issue

Join Shalyam Newsletter

Stay ahead in education, research, and innovation—straight to your inbox.