Renaming Attributes and Relations with an Alias

SELECT SupplierName, avg(price) As “Average Price”, count(*) As “# of Items”

FROM Product P, Supplier S

WHERE P? SupID = S? SupplierIDand Category = ‘Accessories’

GROUP BY SupplierName

ORDER BY SupplierID

alias