Bought Pen But Not Book
Medium
Set Operations
Return customers who bought 'Pen' but never 'Book', using EXCEPT. 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.