DataCamp accepts it like this however yours is correct too:

SELECT 'Average Unit Price' AS [Per Category],

[1], [2], [3], [4], [5], [6], [7], [8]

FROM

(SELECT CategoryID, AVG(UnitPrice) as UnitPrice

FROM Products

GROUP BY CategoryID)...

• This reply was modified 4 years, 6 months ago by  szkat.