38
And Now?
•I still have only the result of:
•         SELECT  seller, buyer, Sum(Price)
•         FROM     Purchase
•         WHERE   Purchase.store = ‘The Bon’
•         Group By seller, buyer
•but I want to answer the query
•         SELECT  seller, Sum(Price)
•         FROM     Purchase
•         WHERE   Person.store = ‘The Bon’   
•         Group By seller
•
•And what if it’s the other way around?
•