2.1.1 Find the names of customers who have ordered item with id 087.
Customer ⋈θ customer.cid=order.cid Order
2.1.2 Find the names of customers who have ordered a television i.e., an item of type television.
Customer ⋈θ customer.cid=order.cid Order (Order order.iid=item.iid Item)
Comments
Leave a comment