I have a query written in Oracle , would like to convert into MySQL -

select *  ( select week_of, count(distinct customer_id) weekly_developer_count,        count(distinct application_id) weekly_app_count ( select pe.event_day_utc, to_char(next_day(pe.event_day_utc - 1, 'sunday'),   'yyyy-mm-dd') week_of, pe.customer_id, pe.application_id   tablename pe      pe.event_day_utc >= sysdate - 90   , pe.event_day_utc < sysdate + 1   , pe.event_name not '%.%' ) group  week_of ) order week_of desc; 

this code have in oracle, mysql doesn't support next_day. idea achieve this?
want output like

weekof applicationcount developercount 2016-17-07  50              10 2016-10-07  60              15 

you can implement own function, described here:

mysql implementation of oracle's next_day