Thanks. I started out trying to do just that - I use aggregate functions in SELECT statements.

I couldn't figure out how to construct the statement by including the SUM and could not find anything on the internet as an example to guide me.