Regarding Operation Metric Project

I tried running the following query for weekly user engagement: select extract(week from strtodate(occurredat, '%d-%m-%Y %H:%i')) as weeknum, count(distinct operationmetrics.events.userid) as active_users from operationmetrics.events left join operationmetrics.users on operationmetrics.events.userid = users.user_id where state = 'active' group by week_num; according to me its correct but I am not getting any output on the screen, neither am I getting an error message. Kindly help so I can know where I have went wrong.