How do I implement this?
I've checked that all the aggregator functions for GROUP BY ignore any NULL values, so I don't know anything else to get NULL when there is one or more NULL values in some grouped set of values from a LEFT JOIN.

Please this is urgent. Any suggestion would be greatly appreciated.