MySQL SQL error in : SELECT DATE_FORMAT(`request_time`, '%d-%m-%Y'),count(*),date(`request_time`) FROM chilterns_log.ink_request_log group by date(`request_time`) order by `request_time` asc
Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'chilterns_log.ink_request_log.request_time' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by