Felix Yan, August 13, 2016 - 12:43 am UTC
Thanks for your response, Chris. That will add to my learing of the function pivot.
I wonder what other SQL functions can we use if the departments are varied and are not limited to the four departments?
For example, there might be a new department Marketing or HR.
Thanks,
Felix
August 14, 2016 - 5:46 am UTC