Mysql-when querying a table, users can collect statistics on new users. notin must use exists.

The following is implemented using notin and needs to be modified to exists to implement SELECTCOUNT (*) fromorder_info_refasoifwhereoif.order_time & gt; & #39; 2016-03-0200:0& #39; andoif. order_time & #39; 2016-03-0100:0& #39; andoi. order_time); mysql

The following is implemented using not in and needs to be modified to exists for implementation.
Select count (*) from order_info_ref as oif where oif. order_time> = '2017-03-02 00:01:00 'and oif. order_time <= '2014-03-02 23:59:59 'and oif. ca_user_id NOT in
(SELECT oi. ca_user_id from order_info_ref as oi where oi. order_time> = '2017-03-01 00:01:00 'and oi. order_time <= '2017-03-01 23:59:59 ');