i found it out. i was needing to find out how to name the column but i wasnt asking the question right. i had to use this statement for the sample database.....
SELECT pid, AVG(cost) AS Average
FROM Catalog AS C
Group by pid

Thanks for helping though