Multiple aggregates and TZ error fixed

* Added multiple aggregates in one query.
* Fixed TZ error.