SELECT Month + ' ' + Product AS NewField, Quantity FROM Sumproduct

SELECT Product FROM Sumproduct

SELECT * FROM Sumproduct WHERE City LIKE '[TN]*'

SELECT DISTINCT Product, Amount/Quantity AS AvgPrice FROM Sumproduct

SELECT DISTINCT Product, Amount/Quantity FROM Sumproduct