i am having an issue when testing this aggregate function. For instance,
i have 2 columns:
Product and Price
when i wrtie sql like this to show the average price; i get this error "Operand data type nchar is invalid for avg operator"
SELECT Product, avg(Price )as total
group by Product