Mailing summary report group by MySQL 5.7 error

Steps to replicate the error:

1. Go to Mailing Summary Report (template/instance)
2. Ensure that 'End Date' is not selected in Columns section.
3. Select 'End Date' in under Sorting form
4. Submit the Criteria

MySql 5.7 Error: nativecode=1055 ** Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'civicrm_db.mailing_job_civireport.end_date' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by|#1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'civicrm_db.mailing_job_civireport.end_date' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by