I have a table that has two fields, ItemCategory - varchar(50) ,and ItemCost - float. I need to write T-SQL to:
1. Calculate the Product of all ItemCost values by ItemCategory.
2. Calculate the Median value of ItemCost by ItemCategory.
How can I do this?
Thanks in advance,