54
Tuple Variables
SELECT DISTINCT x.store
FROM Purchase AS x, Purchase AS y
WHERE
x.product = y.product AND y.store = ‘BestBuy’
Find all stores that sold at
least one product that the store
‘BestBuy’ also sold:
‘BestBuy’ also sold:
Answer (store)
Product (pname, price, category, manufacturer)
Purchase (buyer, seller,
store, product)
Person(persname, phoneNumber, city)