ads_wastage_count

insert into table ads_wastage_count 
select
    '2020-03-20', 
    count(*) 
from 
( 
select 
    mid_id 
from dwt_uv_topic 
where login_date_last<=date_add('2020-03-20',-7)
group by mid_id 
)t1;