Troubleshoot fix resolve ORA-01415: too many distinct aggregate functions

Error Description: The query contains more distinct aggregates than can be processed. The current limit is 255.
Fix for this error: Reduce the number of distinct aggregate functions in the query.