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: