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

Customers Who Bought Both Pen and Book

Return the customer_ids that have bought both 'Pen' and 'Book'. Order by customer_id.

Table schema

Orders(customer_id INT, product VARCHAR(20))

Sample data

customer_id | product
1 | Pen
1 | Book
2 | Pen
3 | Book
3 | Pen
3 | 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.