28
Using a View
SELECT   name, store
FROM      Seattle-view, Product
WHERE   Seattle-view.product = Product.name  AND
                 Product.category = “shoes”
We can later use the view: